Page 210 - CA_165_V2.0_C9_Flipbook
P. 210

D.   Application based questions.
                      1.     Rohit  is preparing  monthly  sales report  with  the  help  of  Spreadsheet.  While typing,  the  text  is not
                          accommodated within the column width. Which option should he use so that text appears properly?
                      2.     Amandeep wants to use shortcut tool for adding the values of a range of cells using the function SUM.
                          Name this tool.

                                                               SECTION C
                                               (Case-based/Passage-based Type Questions)

                  A.   A sheet is the working area or page on the screen. A sheet consists of rows and columns. A spreadsheet is a
                      collection of multiple sheets. (A spreadsheet is like a book and the sheet is like a page of a book). By default,
                      a spreadsheet opens with three sheets, namely Sheet1, Sheet2 and Sheet3. User can change the name of the
                      sheets and may delete or add extra sheets if required. The name of each sheet appears in the sheet tab towards
                      the bottom of the sheet. The active sheet i.e. the sheet being used, is highlighted.
                      1.   Which of the following is a shortcut to open a new spreadsheet?

                          i.  Ctrl+N                                           ii.  Ctrl+W
                          iii.  Ctrl+O                                         iv.  Ctrl+P
                      2.   The extension of a file in OpenOffice Calc is .....................................
                          i.  .xlsx.                                          ii.  .doc

                          iii.  .ods                                          iv.  .odf
                      3.   Which among the following is an active cell in a sheet that is highlighted with a thick boundary?
                          i.  Cell Address                                    ii.  Cell Pointer
                          iii.  Name Box                                      iv.  None of these
                  B.   Sophia is using OpenOffice Calc to maintain the inventory of a small bookstore. She has columns for Item
                      Name, Quantity in Stock, Price per Unit, Total Value, and Supplier Name. She needs to:
                      ●  Enter data for new items in the inventory.

                      ●  AutoFill the Total Value for all items based on the formula.
                      ●  Save the updated inventory report.
                      1.   Which feature will help Sophia quickly copy the Total Value formula to all other rows?

                          i.  Sorting                                         ii.  AutoFill
                          iii.  Data Validation                               iv.  Freeze Panes
                      2.   How should Sophia enter new items in the inventory?
                          i.  Manually type the data into the cells           ii.  Use the Paste function
                          iii.  Create a table                                iv.  Use the Chart function

                      3.   What shortcut key should Sophia use to save the spreadsheet after entering the inventory data?
                          i.  Ctrl + O                                        ii.  Ctrl + P
                          iii.  Ctrl + Z                                      iv.  Ctrl + S













                   208   Touchpad Computer Applications (Ver. 2.0)-IX
   205   206   207   208   209   210   211   212   213   214   215