Page 48 - TP_Pluse_V2.2_Class_6
P. 48

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)  Value

                     d.  A group of selected cells is called ____________.
                        (i)  Selection                                   (ii)  Combination

                        (iii)  Cell range                                (iv)  Table

                     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 given below:

                                               concatenate, if, Functions, MIN(), dollar($)


                     a.  ____________ are predefined formulas in Excel.
                     b.  The ____________ function is a text function.

                     c.  The ____________ function checks the condition and returns True or False.

                     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.

                  46    Plus (Ver. 2.2)-VI
   43   44   45   46   47   48   49   50   51   52   53