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

