Excel Test Grading (Part 1)

A teacher wants to automatically compute the student's grades from the their scores (out of 100) stored in an Excel sheet as shown below:

She also has a table of all the minimum scores required in the same sheet as shown:

The main structure of the Excel sheet is shown below:

If the formula for cell G2 is

=LOOKUP(E2,$B$2:$B$8,$A$2:$A$8)


then which of the following is the correct grade table to be used in the space $A$1:$B$8?

A.

B.

C.

D.

×