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


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






Problem Loading...

Note Loading...

Set Loading...