Question $8(1$ point$)$

$$ Saved

Suppose the range for looking up course grades was sorted ascending $($letter grades of $F$ in the first row and $A+$ in the last row$).$ Looking up course letter grades and quality points in the resorted range would give error conditions because:

the sort order of the lookup values is wrong

lookup values must appear in the last column

the grades and lookup values are mismatched

lookup values must appear in the first column