Formulas and Functions in Excel MCQs
Formulas and Functions in MS Excel – Class 7 MCQs with Answers & Explanations
Class: 7
Subject: Computer Science
Section: Spreadsheets (MS Excel)
Topic: Formulas and Functions in Excel
Board: CBSE (Based on NCERT Syllabus)
Subject: Computer Science
Section: Spreadsheets (MS Excel)
Topic: Formulas and Functions in Excel
Board: CBSE (Based on NCERT Syllabus)
1. A formula in Excel always begins with:
Answer: b) =
The equal sign tells Excel to perform a calculation.
The equal sign tells Excel to perform a calculation.
2. Example of a formula:
Answer: b) =A1+A2
Formulas must start with = sign.
Formulas must start with = sign.
3. Function is a:
Answer: a) Predefined formula
Functions perform quick calculations.
Functions perform quick calculations.
4. SUM function is used to:
Answer: b) Add numbers
SUM calculates total.
SUM calculates total.
5. Function to find average:
Answer: c) AVERAGE
AVERAGE calculates mean value.
AVERAGE calculates mean value.
6. MAX function returns:
Answer: b) Largest
Finds highest value.
Finds highest value.
7. MIN function returns:
Answer: b) Smallest
Finds lowest value.
Finds lowest value.
8. COUNT function counts:
Answer: a) Numbers
Counts numeric cells.
Counts numeric cells.
9. Formula result appears in:
Answer: b) Active cell
Result shows where formula is entered.
Result shows where formula is entered.
10. Cell references are used in:
Answer: b) Formulas
References link calculation cells.
References link calculation cells.
11. Example of cell reference:
Answer: a) A1
12. AutoSum button is for:
Answer: b) Total
13. Formula bar shows:
Answer: c) Both
14. Division operator:
Answer: c) /
15. Multiplication operator:
Answer: a) *
16. Function library is in:
Answer: b) Formulas tab
17. Brackets in formulas are used for:
Answer: a) Priority
18. Error in formula shows:
Answer: d) All
19. Functions save:
Answer: d) All
20. Formulas help in:
Answer: d) All
