Page 195 - IT 402 v2.0 class 10
P. 195

Solved Exercise


                                                             Section A
                                                     (Objective Type Questions)
            A.  Multiple choice questions:
                .   onsolidate option is available under ............................. menu.
                 i.  View                                          ii.  Tool
                   iii. Insert                                     iv.  ata
                .  Subtotals is available in ............................. menu.
                   i.   ools                                       ii.  Format
                   iii. Insert                                     iv.  ata

                .   e can shift from one scenario to another by ............................. .
                   i.  Navigator                                   ii.  Find and  eplace
                   iii.  ata Source                                iv. None of these
                .   o select random multiple cell  hold down ............................. key as you click on each cell.
                 i.  Alt                                           ii.  Shift
                   iii.  trl                                       iv.  ll of these
               5.   hich of the following is more elaborate form of  oal Seek                  S  Sample  aper
                   i.  Scenario                                    ii.  Subtotal
                   iii. Solver                                     iv.  ll of these
                .  If you have two spreadsheets in the same folder linked to each other and you move the entire folder to a new
                 location  a relative hyperlink will ............................. .
                 i.  not work                                      ii.  work
                   iii. may work                                   iv. None of these
                .   hich function cannot be performed through Subtotal in a Spreadsheet        S  Sample  aper
                   i.   Sum                                        ii.   roduct
                   iii.   verage                                   iv.  ercentage
                .  It refers to a cell or a range of cells on a worksheet and can be used to find the values or data that you want
                 formula to calculate.                                                         S  Sample  aper
                 i.   Row                                          ii.  Column
                   iii.   utosum                                   iv.  ell  eferenc
               9.  .............................  totals adds data arranged in an array that is  a group of cells with labels for columns and or
                 rows  hich step one must should follow before using the Subtotal option        S  Sample  aper
                   i.    onsolidate                                ii.   ename  ata
                   iii.  Filter  ata                               iv. Subtotal
              10.  ............................. means combining data in a spreadsheet from different worksheets into master worksheet
                                                                                               S  Sample  aper
                   i.    yperlinks                                 ii.   onsolidating
                   iii.   inking                                   iv. Filter
                .   y default  sheets tab are present at the ............................. of the spreadsheet.       S  Sample  aper
                 i.   Top                                          ii.  Bottom
                   iii.   enter                                    iv.  ight



                                                                       Advanced Features of Spreadsheet        193
   190   191   192   193   194   195   196   197   198   199   200