Class 7 - Chapter 4: Formulas and Functions in Excel

 Chapter 4: Formulas and Functions in Excel

A. Fill in the blanks.

1. Equals to

2. Cell reference 

3. NOW ()

4. Absolute Reference 

5. Arguments

B. State True or False. 

1. True

2. False 

3. True 

4. False 

5. True

C. Select the correct option. 

1. a. TEXTJOIN ()

2. a. =SUM (A2:A8) 

3. b. A3

4. a. Insert Function 

5. a. HelloWorld

D. Competency-based question.

Soumya can use the MAX () function to find the maximum height and MIN () function to find the minimum height from the collected data.

E. Answer the following questions. 

1. Two common errors are:

● ##### Error: This error occurs if the column does not have enough space to accommodate the value.

● #DIV/0!: This error occurs when the number is divided by zero or an empty cell.

2. A formula is an expression that can include cell addresses, numbers, arithmetic operators, and parentheses. It is used to perform calculations such as addition, subtraction, multiplication, and division. For example, to add two numbers, we can use the formula "=A1 + B1," where A1 and B1 are the cell addresses of the numbers that we want to add.

3. The cell address in a formula is known as the cell reference. With the help of references, we can find the values or data in a worksheet that we want to use in the formula. There are three types of cell references: relative, absolute and mixed.

4. Functions are the pre-defined formulas in Excel to perform both simple and complex calculations. Two mathematical functions are: SUM (), and PRODUCT ()

5. Absolute reference is used when we do not want to change the address of the cell while copying the formula to the other cell. To use absolute reference in a formula, we need to add dollar ($) sign before the column and row number. For example, =$A$1+$A$2.