Professor Rao would like to accurately calculate the grades for the 58 students in their Operations Planning and Scheduling class (OM 455).

Rao has thus far constructed a spreadsheet, part of which follows:

a. The Course Average is calculated by weighting the Midterm Score and Final Score 50% each. Use the XLOOKUP function with the table shown to generate the Course Grade for each student in cells E14 through E24.

b. Use the COUNTIF function to determine the number of students receiving each letter grade.

Transcribed Image Text:

1 OM 455 A B C D E 2 Section 001 3 Course Grading Scale Based on Course Average: 45 Lower Upper Course Limit Limit Grade 6 0 59 F 7 60 69 D 8 70 79 C 9 80 89 B 10 90 100 A 11 12 Midterm Final Course Course 13 Last Name Score Score Average Grade 14 Alt 70 56 63.0 15 Amini 95 91 93.0 16 Amoako 82 80 81.0 17 Apland 45 78 61.5 18 Bachman 68 45 56.5 19 Corder 91 98 94.5 20 Desi 87 74 80.5 21 Dransman 60 80 70.0 22 Duffuor 80 93 86.5 23 Finkel 97 98 97.5 24 Foster 90 91 90.5