CBSE SOLUTIONS-2026-27
CLASS-7
CHAPTER-2 MS Excel-Formula and Functions
1. When you copy or move the formula to other cells, the reference cell automatically gets changed known as:
(A) Absolute reference
(B) Relative reference
(C) Mixed reference
(D) None of these
Answer: (B) Relative reference
2. In order to work correctly, a function must be written in a specific way, called the:
(A) Arguments
(B) Equal to
(C) AutoSum
(D) Syntax
Answer: (D) Syntax
3. The AutoSum option is present in the ________ group on the Home tab.
(A) Insert
(B) Editing
(C) Clipboard
(D) None of these
Answer: (B) Editing
4. An error that occurs when the number is divided by 0 is:
(A) #VALUE
(B) #NAME?
(C) #####
(D) #DIV/0!
Answer: (D) #DIV/0!
5. This function finds the largest number in a range:
(A) Average
(B) Count
(C) Max
(D) Min
Answer: (C) Max
B. Write TRUE or FALSE:
1. An Excel formula always begins with an equal to (=) sign.
Answer: TRUE
2. The #VALUE! Error occurs if the formula is used incorrectly.
Answer: TRUE
3. The commonly used functions in MS Excel include Sum, Product, Average, Max, Min and Count.
Answer: TRUE
4. There are six types of cell references in MS Excel 2021.
Answer: FALSE
5. The Paste option is found in the Clipboard group on the Home tab.
Answer: TRUE
C. Fill in the blanks with the words given below:
1. While filling cells, sometimes it is not necessary to ________ a cell reference.
Answer: change
2. Absolute references use a dollar sign ($) to look a specific ________ or part of a cell reference.
Answer: cell
3. In the ________, the first cell address does not include a dollar sign.
Answer: formula
4. In ________ reference, either the row or column remains fixed.
Answer: mixed
5. Most ________ programs allow you to reference cells from different worksheets.
Answer: spreadsheet
.jpg)
.jpg)
