Page 272 - open office
P. 272

B.  Application based questions:                                                          L if e Sk il l s  &  V a l ues
                   1.  Amandeep wants to use a shortcut tool for adding the values of a range of cells. Name this tool.
                 Ans.  Autosum

                   2.  Deepashika is working on her Social Studies project. She is trying to record the data on a spreadsheet about
                      some Indian cities as shown:











                        How will you find out which city has the maximum population and minimum temperature

                 Ans.   MA  (C2:C5)
                         MI  (B2:B5)



              Unsolved Exercise


                                                              Section A
                                                      (Objective Type Questions)

              A.  Multiple choice questions:
                  1.  A function should start with ..................................
                     i.  ‘=’ sign                                           ii.  Alphabets

                     iii.  Numbers                                          iv.  All of the these
                  2.  What is the correct way to enter a function in Calc                               CBSE Handbook
                     i.  Directly typing function name in a cell
                       ii.  Using function wizard or selecting from toolbar

                     iii.  Both i and ii
                     iv.  Depends on the function
                  3.  How can one calculate the total of values entered in a worksheet column
                     i.  By sum function                                    ii.  By auto-sum
                     iii.  By formula                                       iv.  All of these

                  4.  Which of the following type of package does Calc refer to
                     i.  Spreadsheet                                        ii.  Double sheet

                     iii.  Multi-sheet                                      iv.  Cannot be determined
              B.  Fill in the blanks.
                  1.  A  Calc  worksheet contains ................................. columns and 1 ,4 ,5 6 rows.

                  2.  The extension of Calc file is ................................. that automatically gets attached with the file name.
                  3.  By default, ‘Calc’ workbook opens with ................................. worksheets.
                  4.  Active cell in a worksheet is known as ................................. .



               2 2      Touchpad Information Technology-IX
   267   268   269   270   271   272   273   274   275   276   277