Page 90 - PlusGPT_V2.1_C7_Flipbook
P. 90

test Your skiLLs




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

                        (i)  $A$4                                        (ii)  A1

                       (iii)  D6                                        (iv)  B3
                     b.  Which of the following functions is used to calculate the average of a range of values?

                        (i)  AVERAGE                                     (ii)  SUM

                       (iii)  AVG                                       (iv)  INT
                     c.   What is the cell address in a formula called?

                        (i)  Range                                       (ii)  Cell reference

                       (iii)  Mixed reference                           (iv)  Formula

                     d.  What is a group of selected cells called?
                        (i)  Selection                                   (ii)  Combination

                       (iii)  Cell range                                (iv)  Cell reference

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

                                              Functions, Equal to, Dollar ($), Statistical

                     a.                      are predefined formulas in Excel 2016.

                     b. Formulas in Excel 2016 begin with the                      sign.
                     c.                      functions calculates the maximum, minimum, average, etc.
                     d.  In  Mixed  Referencing, you  can lock  either a column  or a row by  preceding  it  with a

                                             symbol.
                  3.  Answer the following:

                     a. What is cell reference?
                          _______________________________________________________________________________________

                          _______________________________________________________________________________________

                     b.  What is the use of the PRODUCT() function?
                          _______________________________________________________________________________________

                          _______________________________________________________________________________________

                     c.  What are date and time functions? Write the names of any two date and time functions.
                          _______________________________________________________________________________________

                          _______________________________________________________________________________________


                  88    Premium Edition-VII
   85   86   87   88   89   90   91   92   93   94   95