Page 50 - Plus_V2.2_C6_Flipbook
P. 50

test Your skiLLs



                  1.  Tick ( ) the correct option.
                     a.  Which one of the following cell references 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

                     d.  A group of selected cells is called ____________.

                        (i)  Selection                                   (ii)  Combination
                        (iii)  Cell range                                (iv)  None of these

                     e.  The ____________ function returns the square root of the given number.
                        (i)  MOD( )                                      (ii)  INT( )

                        (iii)  POWER( )                                  (iv)  SQRT( )
                  2.  Write ‘T’ for True and ‘F’ for False.

                     a.  Every function begins with a + sign.                                           ____________
                     b.  Combined reference is a type of cell reference.                                ____________

                     c.  The NOW( ) function is used to display the current date.                       ____________

                     d.  Excel does not provide functions for working on textual content.               ____________
                     e.  The MAX( ) function returns the largest value from a set of values.            ____________

                  3.  Fill in the blanks using the words from the help box.

                                              equal, square root, Functions, MIN(), dollar($)


                     a.  ____________ are predefined formulas in Excel.
                     b.  Formulas in Excel begin with the ____________ sign.

                     c.  The SQRT( ) function returns the ____________ of the given number.

                     d.   In Mixed Referencing, you can lock either a column or a row by preceding it with a ____________
                        symbol.

                     e.  The ____________ function returns the smallest value.

                  48    Premium Edition-VI
   45   46   47   48   49   50   51   52   53   54   55