Spreadsheets, formulas, functions and charts in MS Excel.
Study notes are still being prepared.
Don't wait — Shishya can teach you this topic right now, on demand.
Ask Shishya to teach this →Shishya is your personal tutor for this topic. Pick a starter or open a free chat.
Q1 · MS Excel · EASY
In MS Excel, what is the correct formula to find the sum of values in cells A1, A2, A3, A4 and A5?
Q2 · MS Excel · MEDIUM
In MS Excel, if cell A1 contains the value 15 and cell B1 contains the value 3, what will be the result of the formula =A1*B1+10?
Q3 · MS Excel · MEDIUM
In MS Excel, which function is used to find the largest value in a range of cells?
Q4 · MS Excel · HARD
In MS Excel, you have sales data in cells B2 to B10. You want to count how many cells in this range have sales greater than 5000. Which formula should you use?
Q5 · MS Excel · MEDIUM
In MS Excel, what does the formula =AVERAGE(A1:A10) calculate?