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

.   ohit scored  5 out of    in  nglish     out of    in Maths.  e wants to calculate the score in I  he needs
                 to achieve  5 percent in aggregate. Suggest him the suitable option out of the following to do so.
                                                                                            S  Sample  aper
                   i.  Macro                                       ii.  Solver

                   iii.   oal Seek                                 iv. Sub  otal
                .   rish and  ritika have done a survey of age wise literacy rates of their locality as a school pro ect  which
                 they have created in a Spreadsheet.  hey both want to work simultaneously to complete it on time.  hich
                 option they should use to access the same Spreadsheet to speed up their work.    S  Sample  aper
                   i.   onsolidate  orksheet                       ii.  Shared  orksheet
                   iii.  ink  orksheet                             iv.  ock  orksheet
                .   hen you open a new spreadsheet  by default  it has a sheet named ............................. which is managed using
                 tabs at the bottom of the spreadsheet.                                     S  Sample  aper
                   i.  Sheet                                       ii.   ntitled

                   iii.  orksheet                                  iv. New Sheet
                .  In a spreadsheet using to create a hyperlink to a web F   or  elnet  click on the ............................. icon available
                 in  yperlink dialog box.                                                   S  Sample  aper
                   i.  browser                                     ii.  hyperlink
                   iii. Internet                                   iv. mail   news
                .     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.  Cell reference                                ii.  Block

                   iii. Sheet  eference                            iv.  utofill
              13.  ............................. function takes data from a series of worksheets or workbooks and summaries it into a single
                 worksheet that you can update easily.                                      S  Sample  aper
                   i    ata  ombination                            ii.  ata Merging
                   iii.  ata  onsolidation                         iv.  ata  oncatenation

            B.  Fill in the Blanks:
                 .   he data consolidation function takes data from a series of worksheets or workbook and summaries it into a
                 ............................. .
                2.  ............................. option reverses the usual order of formula.
                3.  ............................. is a more descriptive form of  oal Seek.
                 .   y default  every workbook contains sheets named ............................. .
                5.  ............................. in spreadsheet are easily recognisable as it is highlighted in light blue colour.

                                                          Section B
                                                 (Subjective Type Questions)
            A.  Answer the following questions:
                 .   xplain the options available under what-if scenarios dialog box
                 .   hich setting options do you need to check before creating a scenario   xplain each of them in short.

                 .   istinguish between the Formula  ell and  ariable cell.
                4.  Write steps to create scenarios.
                5.   rite steps to provide results using multiple operations
                 .   rite the complete procedure to perform  oalSeek in OO  alc.


                                                                       Advanced Features of Spreadsheet        199
   196   197   198   199   200   201   202   203   204   205   206