Question

Given the following spreadsheet write the appropriate formula

expression/function to be used for (a) to (e)

A B C D E F

1 PLAYER ID NAME POINT BONUS RANK TOTAL

2 1 JALDEEP 1300 200 4

3 2 AMANYA 1800 150 1

4 3 MILHIR 1800 100 3

5 4 VARSHA 1200 100 5​

Answer 1

Answer:

3 2 AMANYA 1800 150 1. ..