Page 78 - TechPluse_C6_Flipbook
P. 78

Checkpoint



                  A.    Tick ( ) the correct option.

                         1.   Which of the following cell references can be included in absolute reference?
                              a.   K13                                   c.  $K$13

                              b.  K$13                                   d.  $K13

                         2.   Which one of these functions is used to calculate the average of a range of values?
                              a.   AVERAGE ( )                           c.  SUM ( )

                              b.  AVG ( )                                d.  None of these

                         3.   What is the cell address in the formula known as?
                              a.   Range                                 c.  Cell reference

                              b.  Mixed reference                        d.  None of these

                         4.   Which of the following functions is used to find remainder after dividing two numbers?
                              a.   LEN()                                 c.  MOD()

                              b.  CONCATENATE()                          d.  MAX()

                         5.   In the .......................... chart, bars are placed horizontally.

                              a.   Bar                                   c.  Column

                              b.  Area                                   d.  Line
                         6.   Function name must be followed by opening and closing ...........................

                              a.   Parenthesis                           c.  Curly Brackets

                              b.  Angular Brackets                       d.  Square Brackets

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

                                                  functions, equal, dollar ($), square root, column


                         1.  ...................... are predefined formulas in LibreOffice Calc.

                         2.   Formulas in LibreOffice Calc begin with an ...................... sign.

                         3.   The SQRT function returns the ...................... of the given number.

                         4.   The ...................... chart usually displays the data in the form of vertical bars.

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





               76       Premium Edition-VI
   73   74   75   76   77   78   79   80   81   82   83