Page 53 - TP_Modular_V2.1_Class7
P. 53

Recap


                        A cell or a range of cells that you want to use in your calculation is called reference.
                        Formulas in Excel 2016 begin with an equal to (=) sign.
                         Excel calculates consecutive operators with the same level of precedence from left to right.
                        Excel 2016 allows users to create custom formulas to perform calculations on the data.
                        A cell reference is a cell address that can be used in a formula to denote a specific cell.
                        A group of selected cells is called a range.
                        Functions are pre-defined formulas in Excel to perform simple and complex calculations.
                        Different  categories  of functions are  Statistical functions, Mathematical  functions,
                        Logical functions, Text functions and Date and Time functions.



                                                        Exercise



                 A.  Tick ( ) the correct option.
                    1.  Which of the following cell references can not be included in relative reference?

                       a.  $A$4                   b.  A1                c.  D6                  d.  B3

                    2.  Which of the following functions is used to calculate the average of a range of values?
                       a.  AVERAGE                b.  SUM               c.  AVG                 d.  INT

                    3.  What is the cell address in a formula called?
                       a.  Range                                        b.  Cell reference

                       c.  Mixed reference                              d.  Formula

                    4.  What is a group of selected cells called?

                       a.  Selection              b.  Combination       c.  Cell range          d.  Cell reference

                 B.  Fill in the blanks using the words given below:

                                                 Functions, Equal to, Dollar ($), Square root


                    1.  ................................. are predefined formulas in Excel 2016.

                    2.  Formulas in Excel 2016 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.  Short answer type questions.
                    1.  What is cell reference?

                       .....................................................................................................................................................................................................
                    2.  What is the use of the CONCATENATE( ) function?

                       .....................................................................................................................................................................................................

                                                                                     Formulas and Functions       51
   48   49   50   51   52   53   54   55   56   57   58