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

a    rite the formula to calculate the  otal sales of North  one.
                  b    rite the feature used for arranging the Sales from  owest to the  ighest.
                  c    o find the Maximum Sales in  ast  one.
                  d    o find the  verage Sales in  an-Mar in cell   .
                  e    o find the difference between the sales in  ast  one and  est  one in  pr- un.

              ns.   a    S M    :
                  b   Multiple operations
                  c    M    5 :  5
                  d              :

                  e      5
                .   rint option is available under ............................. menu.
              ns.  File
                .   hat do you mean by Free e in Spreadsheet
              ns.  Free e  anes is spreadsheet means to keep specific rows or columns visible when the user scrolls in the worksheet.
                 It is generally used when the initial rows or columns of the worksheets contain labels.
                .   adya is working on a spreadsheet.  elp her with the solutions for the following:
                   a   Identify the following symbol toolbar:
                   b    enaming a worksheet from sheet  to  ost Sheet.
                   c    o keep the headings constant visible even if she scrolls down.
              ns.   a    utosum
                    b    ight click on sheet tab   Rename

                    c   Free e  anes
                .   iven the following Spreadsheet  write the appropriate Formula  xpression Function to be used for  a  to  e :












                  a    rite formula to calculate the  otal points  Sum of  oints    onus  of each player in cell F    F .
                  b    rite the feature used for arranging the  ank from  ighest to  owest.
                  c    o find the  layer with Maximum  O    to be written to  ell F .
                  d    o find the  verage of  oints to be written in cell   .
                  e    o change the Orientation of the  age from  andscape to  ortrait.
              ns.   a   F
                     F
                     F
                     F5    5    5
                     F
                  b   Sort  escending
                  c    M   F  : F
                  d               :

                  e    iew Æ orientation Æ Portrait


                                                                       Advanced Features of Spreadsheet        203
   200   201   202   203   204   205   206   207   208   209   210