Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 42 - 2505_CoreGPT(Podar)_Flipbook_C7
P. 42

    Checkpoint

                      A.  Tick ( ) the correct option.
                         1.  Which of the following cell references can be included in absolute reference?

                            a.  K13                                          b.  $K$13
                            c.  K$13                                         d.  $K13

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

                            c.  AVG ( )                                      d.  None of these

                         3.  The cell address in the formula is known as .......................
                            a.  Range                                        b.  Cell reference

                            c.  Mixed reference                              d.  Average

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

                            c.  CONCATENATE()                                d.  MAX()

                         5.  Function name must be followed by opening and closing .......................

                            a.  Parenthesis                                  b.  Curly Brackets

                            c.  Angular Brackets                             d.  Square Brackets

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

                         1.  Calc calculates expressions within parentheses first.                            ..........................
                         2.  Logical functions in Calc always return a numeric value as the result.           ..........................

                         3.  Mixed reference is a type of cell reference.                                     ..........................

                         4.  The LOWER function converts the text string into lower case.                     ..........................

                         5.  Calc calculates consecutive operators with the same level of precedence from
                            right to left.                                                                    ..........................

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

                                                     functions, equal (=), dollar ($), square root, ####

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

                     40     Premium Edition-VII

| 37 38 39 40 41 42 43 44 45 46 47 |