Page 37 - Computer Genius Class 06
P. 37
Let's REFRESH
cel allo s users to create custom ormulas to per orm calculations on their data.
cell re erence is a cell address that can e used in a ormula to denote a speci ic cell.
The e ual to sign tells cel that the succeeding characters constitute a ormula.
group o selected cells is called a range.
cel also contains uilt in ormulas called unctions that ma e it easy to per orm common calculations
on data.
eXERCISE
A. Tick ( ) the correct option.
1. hich o the ollo ing cell re erences can e included in the relati e re erence
(i) A3 (ii) A$1
(iii) $A$4 (iv) $D6
2. hich o the ollo ing unction is used to calculate the a erage o a range o alues
(i) AVERAGE (ii) AVG
(iii) SUM (iv) None of these
. hat is a group o selected cells called
(i) Selection (ii) Cell range
(iii) Combination (iv) None of these
. hat does the unction 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 ual to ollar Square root
1. are prede ined ormulas in cel.
2. Formulas in cel egin ith the sign.
. The T unction returns the o the gi en num er.
. n mi ed re erencing you can loc either a column or a ro y preceding it ith a
sym ol.
C. State whether these statements are true or false.
1. ery ormula egins ith a sign.
2. om ined re erence is a type o cell re erence.
. group o selected cells is called a unction.
Formulas and Functions in Excel 35

