Spreadsheets, formulas, functions and charts.
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 / Spreadsheet · EASY
In MS Excel, which function is used to find the sum of a range of cells?
Q2 · MS Excel / Spreadsheet · MEDIUM
If cell A1 contains 50 and cell B1 contains 10, what will be the result of the formula =A1/B1*2 in MS Excel?
Q3 · MS Excel / Spreadsheet · MEDIUM
Which of the following is the correct syntax to use the IF function in MS Excel?
Q4 · MS Excel / Spreadsheet · EASY
In MS Excel, what is the keyboard shortcut to insert the current date in a cell?
Q5 · MS Excel / Spreadsheet · HARD
A shopkeeper records daily sales in cells A1 to A30. He wants to count how many days had sales greater than 5000 rupees. Which formula should he use?