Page 270 - open office
P. 270

B.  Fill in the blanks.
                  1.  ................................. is a feature in Calc by which the cursor can be placed anywhere in a sheet directly.
                  2.  ................................. produces the positive value of a given integer.
                  3.  In a cell, the calculation takes place in the order of precedence of operators in a similar way as .................................
                     in mathematics.

                  4.  ‘Redo’ can be applied by ................................. shortcut.
                  5.  To hide worksheet(s), select the option ................................. from the ‘Format’ menu.
                  6.  If A1:A5 contain the numbers 16, 1 , 3, 25 and 6, then  Average(A1:A5 6 ) will
                     display ................................. .                                        CBSE Handbook
                  Ans. 1.  avigation       2. ABS( )          3. BODMAS           4. Ctrl          5. Sheet      6. 2


                                                              Section B
                                                     (Subjective Type Questions)

              A.  Answer the following questions:
                   1.  Define Worksheet.
                 Ans.  The worksheet in Calc is also referred to as spreadsheet which is the working area. The spreadsheet consists
                      of many sheets. Each sheet has cells arranged in rows and columns. The sheet tab shows its default name as
                      Sheet1, Sheet2, Sheet3 and we can insert more sheets.
                   2.  If cell a1 contains 1  and cell b1 contains 5 , the formula is given in c1 as a1 b1.
                        i.  The cell c1 does not show 6  as answer instead displays a1 b1.What could be the reason
                        ii. Can we give the formula in any other way
                 Ans.  i.  The cell c1 should contain a formula starting with   sign.
                        In cell C1 enter a1 b1
                        ii. We can enter in C1 cell  sum(a1:b1)
                   3.  Give the steps to insert a column in a worksheet.
                 Ans.  Step 1:  Click on the left/right side of the existing column to which a new column has to be inserted on the
                             respective sides.
                      Step 2:  Select the option ‘Columns’ from the ‘Insert’ menu.
                   4.  What is an active cell  How to delete the contents of an active cell             CBSE Handbook
                 Ans.  The selected or activated cell is referred to as an active cell that is always highlighted with a thick border. The
                      address of the active cell is displayed in the name box.
                      To delete the content of an active cell, select the cell and right-click and choose delete cell.
                   5.  Differentiate between the following:
                        i.  Workbook and Worksheet                   ii.  Undo and Redo
                 Ans.  i  A workbook consists of worksheets. Worksheet is the working area or page on the screen. A worksheet
                        consists of rows and columns. (A workbook is like a book and worksheet is like the page of a book). By
                        default, a workbook opens with three worksheets, namely Sheet1, Sheet2 and Sheet3. The 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.
                        ii.  While working in the worksheet, the  Undo  command helps the user to reverse the series of actions and
                         Redo  helps to reverse the actions that have been executed by the  Undo  action.
                         By pressing  Ctrl    or clicking on the  Undo  option from the  Edit  menu or clicking on the  Undo  button
                        from the standard toolbar, we can undo. By pressing  Ctrl    or clicking on the  Redo  option from the  Edit
                        menu or clicking on the ‘Redo’ button from the standard toolbar, we can redo.

               2        Touchpad Information Technology-IX
   265   266   267   268   269   270   271   272   273   274   275