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
C. Fill in the blanks:
1. A________ is a predefined formula that performs calculations using specific values in a particular order.
Answer: Function
2. The ________ feature is particularly useful when you want to add all numbers in a row or a column.
Answer: AutoSum
3. The cell references passed to a function are called_____.
Answer: Arguments or parameters
4. A function must be followed by opening and closing_____.
Answer: Parentheses
5. ________ function is used to add all the numbers in a range of cells.
Answer: SUM
D. Answer the following questions:
1. Differentiate among relative, absolute and mixed references.
Answer:
Relative references change when copied, adjusting both row and column.
Absolute references remain constant when copied, keeping both row and column fixed.
Mixed references have one part fixed while the other adjusts.
2. What is the use of AutoSum feature?
Answer: The AutoSum feature is used to add numbers in the selected range of cells quickly. This feature is particularly useful when we want to add all numbers in a row or a column. The AutoSum option is present in the Editing group on the Home tab.
3. What is a formula? Write the formula to add the contents of cells B4, B5, B6, B7 and multiply the sum by the contents of the cell C10.
Answer: In Excel, a formula is an expression that calculates values based on numbers, cell references, and operators, or predefined formulas called functions. Formulas are used to perform calculations like addition, subtraction, multiplication, and division, or more complex tasks like summing ranges of cells.
Formula for given example: =sum(B4:B7)*C10.
4. What are the different error values that a formula can display? Explain.
Answer: Different error values that a formula can display:
1. #### Error: This error occurs if the column is not having enough space.
2. #VALUE! Error: This error occurs if the formula contains invalid data.
3. #NAME? Error: This error occurs if the formula is used incorrectly.
4. #DIV/0! Error: This error occurs if the number is divided by 0.
5. What do you mean by function? Name some of the commonly used functions.
Answer: A function is a predefined formula that performs calculations using specific values in a particular order. Functions save time and eliminate the chance of writing wrong formulas. All spreadsheet programs include common functions that can be used for quickly finding the sum, average, count, maximum value, and minimum value.
Functions:
* SUM()
* PRODUCT()
* AVERAGE()
* MAX()
* MIN()
* COUNT()
SOME OTHER LINKS:
No comments:
Post a Comment