Page 269 - open office
P. 269

Solved Exercise


                                                                Section A
                                                        (Objective Type Questions)

                 A.  Multiple choice questions:
                     1.  Which of the following contains the address of the current cell/active cell

                       i.  Name Box                                           ii.  Cell Address
                       iii.  Status Bar                                       iv.  None of these
                     2.  Which of the following button is used to calculate the sum of specified range of cells
                       i.  Sum                                                ii.  AutoSum
                       iii.  Formula                                          iv.  None of these
                     3.  ................................. is a symbol that performs certain mathematical or logical operations.
                       i.  Function                                           ii.  Formula
                       iii.  Bullets                                          iv.  Operator

                     4.  Which of the following function produces the current date and time and contains no argument
                       i.  MO TH( Date )                                      ii.  DA ( Date )
                       iii.  TODA ()                                          iv.   OW()
                     5.  ................................. range is the number of selected cells spread across the row and column.
                       i.  Horizontal                                         ii.   ertical
                       iii.  Mixed                                            iv.  None of these
                     6.  What is the active cell in a worksheet known as
                       i.  Cell Address                                       ii.  Cell Pointer
                       iii.  Name Box                                         iii.  None of these
                      .  Which of the following is not a type of data
                       i.  numeric                                            ii.  alpha-numeric

                       iii.  date/time                                        iv.  operator
                      .  Which of the following is an extension of a worksheet created in Calc             CBSE Handbook
                       i.   .ods                                              ii.   .odd
                       iii.  .xls                                             iv.  .obj
                      .  Which of the following is a shortcut key to open a new workbook:

                       i.  Ctrl   W                                           ii.  Ctrl   S
                       iii.  Ctrl                                             iv.  Ctrl
                    1 .  Formula bar lies below the ................................. bar.
                       i.  Formatting Tool                                    ii.  Standard Tool

                       iii.  Status                                           iv.  None of these

                     Ans. 1. i.              2. ii.                3. iv             6. iv.              5. iii
                     .   6. ii.               . iv.               . i                 . iv               1 .i






                                                                                     Working with Spreadsheet       26
   264   265   266   267   268   269   270   271   272   273   274