Computers and Technology, 26.02.2020 17:18 rkingmitch8074

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.

Answers: 2

Show answers

Other questions on the subject: Computers and Technology

Computers and Technology, 21.06.2019 22:00, suyi14

What operating system is a smartphone most likely to use? 1.bsd 2.mac os x 3.symbian 4.linux

Answers: 1

continue

Computers and Technology, 22.06.2019 06:30, lilpeepxliltracy

This technology is used to produce high-quality documents that look good on the computer screen and in print.

Answers: 1

continue

Computers and Technology, 22.06.2019 11:20, destinyleisantos

The kurt vonnegut commencement speech, the neiman-marcus chocolate chip cookie recipe, and the get-well emails to the dying boy are examples of select one: a. social engineering b. hoax emails c. email viruses d. worms

Answers: 1

continue

Computers and Technology, 22.06.2019 18:40, penelopymorales24

Mariah was working on a multimedia presentation that included both video and audio files. the file was huge, and she wanted to send it to her coworker in another office. she needed to reduce the size of the file so that it could be transmitted faster. the utility she used to do this was

Answers: 2

continue

You know the right answer?

8.
Given the following Spreadsheet, write the appropriate Formula/Expression/Function/Options...