Page 60 - TP_Prime_v2.2_Class_6
P. 60
Soft Hint
To use the common functions like Sum, Average, Max and Min:
click on the down-arrow of the AutoSum command.
To use other functions: click on More Functions option.
Prime (Ver. 2.2)-VI Let's Revisit
• Excel 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.
• The equal sign tells Excel that the succeeding characters constitute a formula.
58 • A group of selected cells is called a range.
• Excel also contains built-in formulas called functions that make easy to perform common
calculations on data.
Mind Drill
Rapid Fire
1. Tick (✓) the correct option.
a. ___________ cell reference can be included in relative reference.
(i) A3 (ii) $A$4
(iii) A$1 (iv) $D6
b. Which of the following functions is used to calculate the average of a range of values?
(i) AVERAGE (ii) SUM
(iii) AVG (iv) None of these
c. The cell address in the formula is known as ___________.
(i) Range (ii) Cell reference
(iii) Mixed reference (iv) None of these

