Excel Test Grading (Part 1)Computer Science Level 2
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?