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

Its the VLookup and the HLOOKUP.

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)

i'm pretty sure data is stored in a form

answer assignment page;