Page 292 - TP_IT_V1.0_C10_flipbpookl
P. 292
36. 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.
37. Autosum automatically selects the value around the cells either or . [2017]
38. It contains same types of data: [2017]
a. Table b. Column
c. Row d. None of these
39. Explain any five types of charts available in spreadsheet. [2017]
40. What is conditional formatting? Explain “sort” and “filter” features available in spreadsheet. [2017]
41. What could you do to add an absolute reference? [2016]
a. Add dollar signs around the cell b. Click F4
c. Both (a) and (b) d. None of the above
42. Write the Spreadsheet formula/expressions/functions to perform the operations given in (a) to (e) keeping in view of the
following spreadsheet data: [2016]
a. To calculate AMOUNT with the help of corresponding RENT and DURATION as RENT*DURATION to be written in E2.
b. To calculate TAX as 10% of corresponding AMOUNT to be written in F2.
c. To calculate BILLAMOUNT as total of corresponding AMOUNT and TAX to be written in G2.
d. To find highest RENT from the column B to be written in B8.
e. To count the number of rooms occupied from the column C to be written in C8.
21 st
GROUP DISCUSSION Century #Communication
Skills
Form groups of 3-4 students and discuss the following question: "How can comments in a spreadsheet be used
to enhance team communication and project documentation?"
290 Trackpad Information Technology (Ver. 1.0)-X

