Page 55 - modular4.0
P. 55

Chapter Profile
                     4.  Which mathematical function is used to find the remainder after a number is divided by the divisor?
                         a.  REM                                        b.  SQRT

                         c.   MOD                                       d.  ABS

                     5.  What is the output of = average(3,6,3)?
                         a.  12                                         b.  3

                         c.   4                                         d.  1.2

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

                                                  Arguments, parenthesis, mixed, range

                     1.  Function must be followed by opening and closing                  .
                     2.  A group of selected cells is called a              .

                     3.                      are input to the functions.
                     4.  $A6 is an example of                   referencing.

                 C.   Write ‘T’ for true and ‘F’ for false.

                     1.  Cell references are not helpful when you create complex formulas.
                     2.  A mixed reference is basically a combination of relative and absolute references.
                     3.   It is not possible to create references to cells in other worksheets within the
                         same workbook.

                     4.  =Join(text1,text2) is used to concatenate two different text strings.

                 D.   Short answer type questions.
                     1.  What is the output of =LEFT(“ORANGE”,4)?



                     2.  What are the two ways to enter a formula in a worksheet?


                     3.  Which formula is used to obtain the output 46 for the input =INT(45.789)?


                 E.   Long answer type questions.

                     1.  What are the three elements of a formula?







                     2.  What is the purpose of IF function?






                                                                                              Formulas and Functions  53
   50   51   52   53   54   55   56   57   58   59   60