As shown in the Grades worksheet, final grades are determined using the following grading scheme:
• Students earning over 900 points receive an A.
• Students earning less than 900 points but at least 800 points receive a B.
• Students earning less than 800 points but at least 700 points receive a C.
• Students earning less than 700 points but at least 600 points receive a D.
• Students earning less than 600 points receive an F.
Write a formula in cell C3 in the Scores worksheet that determines the final grade for the first student based on the grading scheme. Use the appropriate Reference and Lookup function and write the formula so that it can be copied down the column.
