Page 79 - TechPluse_C6_Flipbook
P. 79

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?

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


                 F.    Long answer type questions.
                       1.   What do you mean by Formula? Explain with examples.

                       2.   What are the certain rules of precedence that Calc follows?
                       3.   What is the use of the CONACTENATE function? Explain with example.

                       4.   What are rules to enter a function?

                       5.   Differentiate between Column chart and Bar chart.



                                                                        Formulas, Functions and Charts in Calc       77
   74   75   76   77   78   79   80   81   82   83   84