Page 33 - Touchpad_Plus_V3.2_Class 7
P. 33

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.
                      .....................................................................................................................................................................................

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



                                                       Mind Boggler


                 A.  Competency-based/Application-based questions.                             Century   #Technology Literacy
                                                                                                 21 st
                    1.  Suman wants to present the information in the form of a chart. She       Skills
                       has a data of single series and the graph must show relative circular size of each
                       value. Which chart type must she use?
                    2.  Ankita has made a spreadsheet for the marks obtained by the students of her
                       class indifferent subjects. Which feature should she use to keep the marksheet
                       updated if she has to change marks in one of the subjects for any student?

                 B.  Solve the crossword using the given clues.                                    21 st
                                                                                                 Century   #Critical Thinking
                    Down                                                                           Skills
                    1.  Cell address that is to be used in a calculation
                    2.  Function used to display current date
                    4.  Function used to add values in cells

                    6.  Predefined formula in Calc
                    7.  Chart type in which data is displayed in the form of vertical bars

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