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
   32   33   34   35   36   37   38   39   40   41   42