Given a student's numerical average and a table that lists the grades and percent needed to obtain the grades in column format,which Excel function would be used to determine the student's letter grade?
A) MATCH
B) INDEX
C) HLOOKUP
D) VLOOKUP

Question

Quizplus · Accepted Answer

VLOOKUP is the best choice as it allows searching for a value in the leftmost column of a table and returns the corresponding value from a specified column in the same row. This makes it ideal for looking up a student's letter grade based on their numerical average and the associated percent required for each grade.

Given a Student's Numerical Average and a Table That Lists