Page 32 - TP-Play_V-2.0_Book-6
P. 32
Recap
A cell or a range of cells that you want to use in your calculation is called reference.
Formulas in Excel 2016 begin with an equal to (=) sign.
Excel calculates consecutive operators with the same level of precedence from left to
right.
Excel 2016 allows users to create custom formulas to perform calculations on their data.
A cell reference is a cell address that can be used in a formula to denote a specific cell.
A group of selected cells is called a range.
Exercise
A. Tick ( ) the correct option.
1. Which of the following cell references can be included in relative reference?
a. $A$4 b. A1
c. D6 d. All of these
2. Which of the following functions is used to calculate the average of a range of values?
a. AVERAGE b. SUM
c. AVG d. All of these
3. What is the cell address in a formula called?
a. Range b. Cell reference
c. Mixed reference d. None of these
4. What is a group of selected cells called?
a. Selection b. Combination
c. Cell range d. All of these
5. The NOW( ) function is used to display the current ............................... .
a. Date b. Time
c. Both a. and b. d. None of these
B. Fill in the blanks using the words given below.
functions, equal to, dollar ($), square root
1. ................................. are predefined formulas in Excel 2016.
2. Formulas in Excel 2016 begin with the ................................. sign.
3. The SQRT function returns the ................................. of the given number.
4. In Mixed Referencing, you can lock either a column or a row by preceding it with a
................................. symbol.
32 Play (Ver. 2.0)-VI

