Page 31 - Touchpad_Plus_V3.2_Class 7
P. 31

Restart


                       LibreOffice Calc allows users to create custom formulas to perform calculations on their
                      data.
                      Formulas in LibreOffice Calc begin with an equal sign.
                      When performing calculations using a formula, Calc follows certain rules of precedence.
                       Calc also contains built-in formulas called functions that make it easy to perform common
                      calculations on data.
                       Charts make it easier to draw comparisons, analyse growth and relationship among the
                      values.





                                                          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.  In the ...................... chart, bars are placed horizontally.
                       a.  Bar                                          b.  Column

                       c.  Area                                         d.  Line

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

                       a.  Parenthesis                                  b.  Curly Brackets

                       c.  Angular Brackets                             d.  Square Brackets




                                                                        Formulas, Functions and Charts in Calc       29
   26   27   28   29   30   31   32   33   34   35   36