Using the information in the format shown below and given a student's numerical average,which Excel function would be used to determine the student's letter grade?

A)VLOOKUP
B)HLOOKUP
C)INDEX
D)MATCH

Question

Using the information in the format shown below and given a student's numerical average,which Excel function would be used to determine the student's letter grade?

A)VLOOKUP 
B)HLOOKUP 
C)INDEX 
D)MATCH

Quizplus · Accepted Answer

VLOOKUP is the best choice as it allows us to look up the student's average in a table, match it to a corresponding letter grade, and return that grade as the output. This is particularly useful when dealing with large sets of data and when the grade range is not evenly spaced or weighted.

Using the Information in the Format Shown Below and Given