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

    Type the desired name of the worksheet.
                     The sheet is renamed.

                .   rite the syntax to create a cell reference to other worksheet  for individual cell and for ranges of cell
              ns.  Syntax to create reference to an Individual  ell: Sheet name. ell address Syntax to create reference to a  ange of
                  ells: Sheet name.First cell: ast cell
              15.  ............................. key is an accessibility function which is designed for people who have vision impairment or cognitive
                 disabilities.                                                                  S  Sample  aper
             Ans.  Toggle key.
                .  efine the following:                                                         S  Sample  aper
                  a   Subtotals
                  b   Consolidating  ata
              ns.   a   Subtotal adds data arranged in an array that is  a group of cells with labels for columns and or rows. It is
                     available in  ata  ab  using the Subtotals dialog  you can select arrays  and then choose a statistical function
                     such as  ount  Min  Max etc. to be applied on arrays. For e ciency  one must choose up to three groups of
                     arrays to which to apply a function.
                  b    onsolidate provides a graphical interface for copying data from one range of cells to another, then running
                     one of a do en functions on the data. During consolidation  the contents of cells from several sheets can be
                     combined in one place.
                                                                                                     I nte r - D is cip l inar y
            B.  Application based questions:
                 .   onsider a worksheet in which a student wants to predict target marks he she can obtain after an exam. Suppose
                 in a sub ect say  omputer  the worksheet containing pass percentage     cell      maximum marks in the exam
                 say  5  in cell  5   target marks he she wants to achieve say  5   in cell      actual marks he she obtained 5   in
                 cell B7).
                 i.   he calculation formula of percentage in  cell    .
                 ii.  In column    enter a variety of alternative marks if obtained  one below other  for example      5   5     and   .
                 iii.  alculate the percentage of alternate marks obtained that get displayed in column  .















              ns:  i.   he calculation formula for percentage in  cell    .          5
                 ii.  ust enter the values given in the mentioned cells.
                 iii.           5
               2.   alculating with several formulas simultaneously:










                 i.  In the above sheet  delete the contents of column  . Insert a column after column    for calculating less marks
                   obtained than target .


                                                                       Advanced Features of Spreadsheet        197
   194   195   196   197   198   199   200   201   202   203   204