Page 196 - CA 165 ver 1.0 Class 9
P. 196

B.   Case Based MCQs
                        Worksheet is the working area or page on the screen. A worksheet consists of rows and columns. A workbook
                      is a collection of multiple worksheets. (A workbook is like a book and the worksheet is like a page of a book).
                      By default, a workbook opens with three worksheets, 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 worksheet. The active sheet i.e. the sheet being used, is highlighted.
                      1.  Which of the following is a shortcut to open a new workbook?
                          i.  Ctrl+N                                          ii.  Ctrl+W
                          iii.  Ctrl+O                                        iv.  Ctrl+P
                      2.   The extension of a file in Calc is .....................................

                          i.  .xlsx.                                          ii.  .doc
                          iii.  .ods                                          iv.  .odf
                      3.   Which among the following is an active cell in a worksheet that is highlighted with a thick boundary?
                          i.  Cell Address                                    ii.  Cell Pointer
                          iii.  Name Box                                      iv.  None of these
                  C.   Fill in the blanks.
                      1.   A ‘Calc’ worksheet contains .................................... columns and 65,536 rows.
                      2.   .................................... helps to change the  direction of contents in a cell.

                      3.   Series of numbers can be filled using .................................... feature.
                      4.   .................................... button is used to enter or edit formula in Calc.
                      5.   The extension of Calc file is .................................... which automatically gets attached with the file name.

                                                                 PART B


                  A.   Short answer type questions.
                      1.   How can a sheet of workbook be hidden?
                      2.   How will you add a new sheet in your workbook?
                      3.   Explain the ‘Autofill’ feature of Spreadsheet.
                      4.   What are the different types of data that can be entered in the cells?

                      5.   Differentiate between Wrap Text and Shrink to fit cell size.
                  B.   Long answer type questions.
                      1.   Explain any two logical functions with example.

                      2.   Define Operators. List and describe all the operators.
                      3.   Write down the steps to hide columns in OpenOffice Calc.
                      4.   Write short notes on:
                          i.  Formula Bar                                     ii.  Operands
                          iii.  Sheet Tab                                     iv.  Formatting Cells

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



                   194    Touchpad Computer Applications-IX
   191   192   193   194   195   196   197   198   199   200   201