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

5.   istinguish between the following with respect to spreadsheets:
                   a    elative and  bsolute  yperlink.         b   Internet and  ocument  yperlink.
              ns.   a    Relative and Absolute Hyperlinks:  n absolute link will stop working only if the target is moved.   relative
                     link will stop working only if the start and target locations change relative to each other. For instance  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 not break.
                    b   Internet and Document Hyperlinks:  he hyperlink points to a web address  normally starting with http:   or
                     https:   is known as internet hyperlink whereas the hyperlink points to a place in either the current worksheet
                     or another existing worksheet document hyperlink.

                6.  ............................. function takes data from a series of worksheets or workbooks and summaries it into a single
                 worksheet that you can update easily.
                   a   Summation                                b    ata  onsolidation
                   c    ata Format                              d    ata  hart
              ns.   b
                 .  If you are continually working with the same range  then you may give a name to the range using .............................
                 option under  ata Menu.
                   a    efine data                              b    efine range
                   c    efine reference                         d    efine address
              ns.   b
                 .  In  alc  using the Subtotals dialog  you can select arrays and then choose a statistical function to apply to them.
                 For e ciency  you can choose up to ............................. groups of array to which to apply a function.
                   a   two                                         b  three
                   c   four                                        d  five
              ns.   c
                 .  Solve option under  ools menu amounts to a more elaborate form of ............................. .  he difference is that the
                 Solver deals with e uations with multiple ............................. .
                   a    nknown variables   oals Seek            b    ariables    uation
                   c    oal seek   nknown variables             d   Subtotal   oal seek
              ns.   c
                .   sually  you run a formula to calculate a result based upon existing values.  y contrast  using  you can discover
                 what values will produce the result that you want.
                   a   Subtotal                                 b   Scenario
                   c   Sort  ists                               d    oal Seek
              ns.   d
                .   ama and two of her friends are doing survey of gender wise employment rates of their locality as a school pro ect
                 using Spreadsheet.  hey all want to work simultaneously to complete it on time.  hat option they should use to
                 access the same Spreadsheet to speed up their work.
                   a    onsolidate  orksheet                    b   Shared  orksheet
                   c    ink  orksheet                           d    ock  orksheet

              ns.   b
                .  In  alc  you can use a cell reference in one or several formulas to refer to :
                   a    ata from one or more contiguous cells on the worksheet
                   b    ata contained in any software
                   c    ata contained in any format in databases
                   d   Images in picture gallery
              ns.   a


                                                                       Advanced Features of Spreadsheet        201
   198   199   200   201   202   203   204   205   206   207   208