10. You are given the following worksheet: Student Scores Grading Scheme 2 Name

Question

10. You are given the following worksheet: Student Scores Grading Scheme 2 Name Total Points Letter Grade 3 Loanna 4 vijay S Paul 6 Ying 7 Rebecca 8 Roberto 700 800 900 845 694 933 So As shown in the worksheet, final grades are determine 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 carning less than 600 points receive an F Write a formula in cell C3 that determines the final grade for the first student based on the grading scheme. Use the appropriate Reference and can be copied down the column. (10 Points) Lookup function and write down the formula so that it

Explanation / Answer

=LOOKUP(B2,E2:I3)

LOOKUP function has 2 arguments 1. lookup value(total points) 2. array (grading scheme)

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.