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
D. Answer these questions:
1. What is a formula? How can you calculate the total of the values in cells B4, B5, B6 and B7 and then multiply?
Answer:
A formula is an expression that performs calculations on the values present in the cells of a spreadsheet. A formula always starts with an equal sign (=).
To calculate the total (sum) of the sales values in cells B4, B5, B6, and B7 and then multiply all those sales values together (i.e., product of B4 × B5 × B6 × B7), we use the following functions:
Step 1: Calculate the sum of all sales using SUM function:
=SUM(B4:B7)
Step 2: Calculate the product (multiplication) of all sales values using PRODUCT function:
=PRODUCT(B4:B7)
2. What is a cell reference? What are its types?
Answer:
A cell reference is the address of a particular cell in a spreadsheet (example: A1, B5).
Its types are:
Relative Reference
Absolute Reference
Mixed Reference
3. How do relative, absolute and mixed references differ?
Answer:
Relative Reference: Both row and column change when formula is copied. Example: A1
Absolute Reference: Neither row nor column changes when copied. Example: $A$1
Mixed Reference: Only row or only column remains fixed. Example: $A1 or A$1
4. What is a function? Name some common functions.
Answer:
A function is a pre-defined formula in spreadsheet software that performs specific calculations automatically.
Common functions: SUM, AVERAGE, COUNT, MAX, MIN, IF, VLOOKUP, TODAY.
5. What is the purpose of the AutoSum feature?
Answer:
The purpose of AutoSum is to quickly add up a range of numbers in a column or row by automatically inserting the SUM function.
6. What are the various error messages a formula might show? Explain.
Answer:
Common formula error messages are:
#DIV/0! : Division by zero
#VALUE! : Wrong data type used
#REF! : Invalid cell reference
#NAME? : Function name not recognized
#N/A : Value not available
#NUM! : Invalid numeric calculation
##### : Column width is not enough
YOU MAY LIKE:
No comments:
Post a Comment