Page 35 - TP_Play_V2.1_class6
P. 35
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 the 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.
Functions are pre-defined formulas in Excel to perform simple and complex calculations.
Different categories of functions are Statistical functions, Mathematical functions,
Logical functions, Text functions and Date and Time functions.
Exercise
A. Tick (✓) the correct option.
1. Which of the following cell references can not be included in relative reference?
a. $A$4 b. A1 c. D6 d. B3
2. Which of the following functions is used to calculate the average of a range of values?
a. AVERAGE b. SUM c. AVG d. INT
3. What is the cell address in a formula called?
a. Range b. Cell reference
c. Mixed reference d. Formula
4. What is a group of selected cells called?
a. Selection b. Combination c. Cell range d. Cell reference
5. The NOW( ) function is used to display the current ............................... .
a. Date b. Time c. Both a. and b. d. Year
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.
C. Short answer type questions.
1. What is cell reference?
.....................................................................................................................................................................................................
Formulas and Functions 33

