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.
This section requires Javascript.
You are seeing this because something didn't load right. We suggest you, (a) try
refreshing the page, (b) enabling javascript if it is disabled on your browser and,
finally, (c)
loading the
non-javascript version of this page
. We're sorry about the hassle.
1 solution
: The values in lookup_vector must be placed in ascending order: ..., -2, -1, 0, 1, 2, ..., A-Z, FALSE, TRUE; otherwise, LOOKUP might not return the correct value.