Page 37 - Digicode_AI_class_6
P. 37
REFRESH
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 to sign (=) tells 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.
TeCh Ready
A. Tick ( ) the correct option.
1. Which of the following cell references can be included in the relative reference?
(i) A3 (ii) A$1
(iii) $A$4 (iv) $D6
2. Which of the following function is used to calculate the average of a range of values?
(i) AVERAGE (ii) AVG
(iii) SUM (iv) None of these
3. What is a group of selected cells called?
(i) Selection (ii) Cell range
(iii) Combination (iv) None of these
4. What does the NOW() function display?
(i) Date (ii) Time
(iii) Both (i) and (ii) (iv) 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.
2. Formulas in 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 a row by preceding it with a
symbol.
C. State whether these statements are true or false.
1. Every formula begins with a + sign.
2. Combined reference is a type of cell reference.
3. A group of selected cells is called a function.
Formulas and Functions in Excel 35

