please show work

Assignment 2 OM 455 Given below is the grading scale and the midterm and final scores of students in course OM 455 The semester in the average of the mid-term and final scores a. Determine the course awape and then based on that determine the studentscourse grade using the VLOOKUP unction Determine the number of students securing each course grade using the COUNTIFunction Courserading Scalated on Course Average Lower upper Course Course Grade Number of students LE Grade D 60 50 D 70 79 0 B A 00 100 00 Course Average Course Grade Last Name AH AN Amaha Apland Bachman Corder Midterm score 70 95 2 45 100 Final Score 50 01 10 70 45 Der 74 10 Danman Dutor Fine Toile Fu Deorge Gerson Dining O. Goto H Heiman 65 32 77 93 35 * o 655 PM 2/1/2022 Lo Scarch a BE Raining now 03. 88 57 100 06 70 86 97 90 88 Hotman Hibbard Hils Hughes Hutchison Jackson Kassner Kalck Kom Kinner Lar Marth Martin Mattiin McGough Mitter Minnick Minster Muote Munzo Nanko Owen Roth Reza Ridder Rodgers Ruschau Schneider Schning Schwartz Scott Shaw Sims Steiman Trenta Van Wetter WE 88 85 87 74 40 35 00 88 67 70 74 05 50 06 60 80 83 70 09 n 67 93 94 70 87 72 74 75 51 45 53 74 80 70 30 100 70 97 90 96 93 80 76 07 68 70 72 03 61 78 54 S1"F Rain 90 do Lair Marsh Martini Mattiin McGough Miller Minnick Minster Mueller Munzo Nanko Owen Reth Rozal Ridder Rodgers Ruschau Schneider Schniring Schwartz Scott Shaw Sims Steelman Trentman Villaris Wettee Weyer Whipky Willis 90 88 67 78 74 65 58 66 68 86 83 54 70 95 81 87 72 74 75 51 45 63 74 83 65 78 64 93 88 90 97 96 88 84 78 80 93 67 93 94 96 78 86 100 79 97 90 96 93 81 76 87 68 79 72 83 61 95 90 95