Page 32 - Touchpad_Plus_V3.2_Class 7
P. 32

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.


                  C.  Write ‘T’ for true and ‘F’ for false.
                     1.  Calc calculates expressions within parentheses first.                            ..........................

                     2.  Legend is a key which shows the meanings of symbols and colours used in the chart.   ..........................
                     3.  Combined reference is a type of cell reference.                                  ..........................

                     4.  We cannot create Bar chart in Calc.                                              ..........................
                     5.  Calc calculates consecutive operators with the same level of precedence from
                        right to left.                                                                    ..........................


                  D.  Match the columns.

                         Column A                             Column B
                     1. Area chart                        a. Trends over period of time

                     2. Pie chart                         b. Quantitative magnitude of data
                     3. Bar chart                         c. Sector showing relative size of each value

                     4. Line chart                        d. Long rectangular rods to represent data

                  E.  Short answer type questions.

                     1.  What is cell reference?
                       .....................................................................................................................................................................................

                     2.  What is category axis in a chart?
                       .....................................................................................................................................................................................

                     3.  Define Legend.

                       .....................................................................................................................................................................................
                     4.  What is the use of the LEN function?

                       .....................................................................................................................................................................................





               30       Plus (Ver. 3.2)-VII
   27   28   29   30   31   32   33   34   35   36   37