Question

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

Answer 1

Answer:

bkkkkkkkkkkkkkkkkkkkkkkkkkk