You wish to enter your exam scores in a spreadsheet. Which function will help you find how each subject’s score relates to the o

Question

Studentka2010 [4]

3 years ago

8

You wish to enter your exam scores in a spreadsheet. Which function will help you find how each subject’s score relates to the o

thers? The __function will help to identify where each subject’s score stands with respect to others.

Computers and Technology

1 answer:

tester [92] · Answer 1 · 2022-06-06T05:48:53+03:00

Answer:

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)