8.
Given the following Spreadsheet, write the appropriate Formula/Expression/Function/Options to
be used for (a) to (e):
Η.
Total
COOL AWN
1 Player ID Name
1 Jaideep Singh
2 Ananya Grover
3 Mihir Sharma
4 Varsha Pandey
5 Sandeep Singh
Points Bonus
1300
1800
16001
1200
1700
Rank
200
150
100
100
200
(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.