Question

You wish to enter your exam scores in a spreadsheet. Which function will help you find how each subject’s score relates to the others? The __function will help to identify where each subject’s score stands with respect to others.

Answer 1

Rank

Step-by-step explanation:

Answer 2

Its the VLookup and the HLOOKUP.

Step-by-step explanation:

And it depends upon the manner in which the marks are mentioned. If they are mentioned in row then we use Hlookup, and if in columns then we use vlookup.

And the syntax for vlookup is :

vlookup(lookup value, range containing the lookup value, column number in range containing the return value, approximate 0 or exact value 1)