Page 47 - ModularV1.1 _c7_flipbook
P. 47
Recap
A cell or a range of cells that you want to use in your calculation is called reference.
Formulas in MS Excel begin with an equal to (=) sign.
Excel calculates consecutive operators with the same level of precedence from left to
right.
MS 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 MS Excel that the succeeding characters constitute a formula.
A group of selected cells is called a range.
Excel also contains built-in formulas called functions that make it easy to perform
common calculations on data.
Exercise
A. Tick ( ) the correct option.
1. Which one of the following cell references can be included in relative reference?
a. $A$4 b. A1 c. D6
2. Which of the following functions is used to calculate the average of a range of values?
a. Average b. SUM c. AVG
3. What is the cell address in a formula called?
a. Range b. Cell reference c. Mixed reference
4. What is a group of selected cells called?
a. Selection b. Combination c. Cell range
5. The NOW( ) function is used to display the current ............................... .
a. Date b. Time c. Both a and b
B. Fill in the blanks using the words given below.
functions, equal to, dollar ($), square root
1. ................................. are pre-defined formulas in MS Excel.
2. Formulas in MS Excel 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 row by preceding it with a
................................. symbol.
Formulas and Functions 45

