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
   55   56   57   58   59   60   61   62   63   64   65