Page 261 - Trackpad 402_Class-X_Final
P. 261

14.  Autosum automatically selects the values around the cells either    or             .        [2020]
              15.  Given the following Spreadsheet, write the appropriate Formula/Expression/Function to be used for (a) to (e):   [2020]















                  a. Write the formula to calculate the Total sales of North Zone.
                  b. Write the feature used for arranging the Sales from Lowest to the Highest.
                  c. To find the Maximum Sales in East Zone.
                  d. To find the Average Sales in Jan-Mar in cell C7.
                  e. To find the difference between the sales in East Zone and West Zone in Apr-Jun.
              16.  Print option is available under       menu.                                                 [2019]
              17.  What do you mean by Freeze in Spreadsheet ?                                                 [2019]
              18.  Given the following Spreadsheet, write the appropriate Formula/Expression/Function to be used for (a) to (e):   [2018]














                  a. Write formula to calculate the Total points (Sum of Points + Bonus) of each player in cell F2 – F6.
                  b. Write the feature used for arranging the Rank from Highest to Lowest.
                  c. To find the Player with Maximum TOTAL to be written to Cell F7.
                  d. To find the Average of Points to be written in cell C7.
                  e. To change the Orientation of the Page from Landscape to Portrait.
              19.  Aadya is working on a spreadsheet. Help her with the solutions for the following:           [2018]
                  a. Identify the following symbol/toolbar : Σ
                  b. Renaming a worksheet from sheet1 to Cost Sheet.
                  c. To keep the headings constant/visible even if she scrolls down.
              20.  Autosum automatically selects the value around the cells either    or             .         [2017]
              21.  It contains same types of data:                                                             [2017]
                  a. Table                                          b. Column
                  c. Row                                            d. None of these
              22.  Explain any five types of charts available in spreadsheet.                                  [2017]
              23.  Write the Spreadsheet formula/expressions/functions to perform the operations given in (a) to (e) keeping in view of the
                  following spreadsheet data:                                                                  [2016]













                                                                                 Electronic Spreadsheet (Advanced)  261
   256   257   258   259   260   261   262   263   264   265   266