CBSE SOLUTIONS-2025-26
CLASS-7
CHAPTER-2 ADVANCED FEATURES OF MS EXCEL
A. Tick the correct answer:
1. Which of the following is not in the AutoSum menu?
a. Add b. Average c. Max d. Min
Answer: Add
2. An error which occurs when the number is divided by 0 is:
a. #### b. #VALUE c. #NAME? d. #DIV/0!
Answer: #DIV/0!
3. What symbol do Microsoft Excel formulas start with?
a. + b. * c. / d. =
Answer: =
4. Which function finds the largest number in a range?
a. Average b. Count c. Max d. Min
Answer: Max
5. To modify a formula, select the cell containing the formula and then press the _____ key.
a. F1 b. F2 c. F3 d. F4
Answer: F2
B. Write T for true and F for false:
1. The AutoSum option is present in the editing group on the home tab.
Answer: T
2. Microsoft Excel formulas can start with the '+' sign.
Answer: F
3. Formulas in Microsoft Excel are case sensitive.
Answer: F
4. The count numbers function counts the cells in a range having numeric data.
Answer: T
5. Functions save time and eliminate the chance to write wrong formulas.
Answer: T