Class 7 Computer Science: MS Excel Formulas and Functions
Answer the questions and tap Submit to see your score. Your progress is auto-saved on this device.
Jump to question
Q1 · MCQ · 1 mark
Which symbol must all formulas in MS Excel begin with?
Q2 · MCQ · 1 mark
Which of the following is an example of a cell address in Excel?
Q3 · FILL · 1 mark
A predefined formula that performs calculations in Excel is called a _________.
Q4 · MCQ · 1 mark
Which function is used to add a range of numbers in Excel?
Q5 · SHORT · 2 marks
What is the purpose of a formula in MS Excel?
Q6 · MCQ · 1 mark
If you want to find the largest number in a range of cells (e.g., A1:A10), which function would you use?
Q7 · FILL · 1 mark
The function to find the average of a range of numbers is _________.
Q8 · MCQ · 1 mark
Which of the following is NOT a valid operator used in Excel formulas?
Q9 · FILL · 1 mark
A range of cells is indicated by the starting cell address followed by a colon (:) and the _________ cell address.
Q10 · SHORT · 2 marks
Explain the difference between a formula and a function in Excel.