Page 78 - Code & Click - 6

Info Retention

A. Select the correct option for each of the following statements.
1. An equation used to perform calculation on the data and produce a result in a worksheet is

called a ______.

(a) Formula (b) Operator (c) Constant (d) Expression

2. If the formula = C2 + $D$2 in cell E2 is copied to cell E3, the new formula in cell E3 will be
______.

(a) = C3 + $D$3 (b) = C3 + $D$2 (c) = C3 + $E$3 (d) = C3 + E3

3. The values that a function in Excel uses to perform calculations are called ______.

(a) arguments (b) formula (c) cell reference (d) operators

4. The result of the formula = Product(Sum(23, 42), 5) in a cell in Excel is ______.

(a) 4830 (b) 325 (c) 70 (d) 157

B. Fill in the blanks with the correct answer.

1. _____________ are in-built formulas in Excel that you can use to perform calculations in a
worksheet.

2. The _____________ feature allows you to quickly add the values of a selected cell range.

3. $F$5 is an example of _____________ cell reference.
4. By default, Excel uses _____________ cell references when copying a formula from one cell
to another cell.

C. Write ‘T’ for True and ‘F’ for False statement.

1. All Formulas in Excel start with an equal (=) sign. _______
2. The error #NUM! occurs when the formula contains an invalid numeric value. _______

3. In absolute referencing, only one cell reference – row or column, is fixed. _______

4. The COUNT( ) function is used to find the number of cells that contain numerical
values in a specified cell range. _______

D. Answer the following questions.

1. Write the different ways to enter a cell reference in a formula.
2. What is a function? Write any four functions with their uses in Excel.

3. Explain the three types of cell referencing in Excel with an example of each.

4. Describe any five errors that occur while using formulas in Excel.

76