Question

Given the following Spreadsheet, write the appropriate Formula/Expression/Function tobe used for (a) to (e):
A B C D E F G
Player ID Name Points Bonus Rank Total
1 Jaideep Singh 1300 200 4
2 Ananya Grover 1800 150 1
3 Mihir Sharma 1600 100 3
4 Varsha Pandey 1200 100 5
5 Sandeep Singh 1700 200 2
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 the 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

tex

huge

bold

Formula/Expression/Function tobe used for (a) to (e):

A B C D E F G

Player ID Name Points Bonus Rank Total

1 Jaideep Singh 1300 200 4

2 Ananya Grover 1800 150 1

3 Mihir Sharma 1600 100 3

4 Varsha Pandey 1200 100 5

5 Sandeep Singh 1700 200 2

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 the 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.