explain step by step .

explain step by step

4:04 TikTok Done Assignment 2.xlsx a indicated below is the Coun Gating saho the Mand Schwed by atento the date of Ones The courte vragen en of iemande Frauere Determine the course rage and based on the course Average setemiere Course Grade ning the VLOOKUP Unction Using the Count function commune the number of studera geting each other adee how many AB Courte Grading Scan used on Course Average Usper Course Limit Lima Grade 0 30 60 TO YO c 10 ED 90 500 A Course Average Course Grade Last Name AH Amini Michem Score YO 95 2 Apland Bachman Corder 91 82 60 80 Desi Dransman Duur Finkel Foster Fuss Final Score 56 1 80 78 45 98 74 80 93 98 91 82 92 76 66 100 72 93 88 4 90 74 George Gerson Gring Groer Guero Hager Hellman Hibband His Hughes Hachon Jackson Kasse KR kom Kinner 95 70 65 82 95 62 78 88 85 93 95 100 90 74 45 55 90 88 78 86 97 Marsh Mart Man Medog 88 84 78 80 93 74 65 58 06 68 26 83 54 70 95 81 93 94 Narke 78 86 100 10 23 Milor Minnick Master M Marso Owen Reth New Rader Rodgers Ruchu Schneider Schwing Schwartz Scott Sh Sims Sleman Tretman Van Wittee Weyer Whipky Wie 93 13 81 1 YA 76 72 74 10 7 54 51 45 63 14 3 05 TB 64 90 88 90 68 20 72 61 95 90 95 Q. Indicated below is the Course Grading scale as also the Mid Term and Final Scores achieved by students in the class of OM 455, The course average is the average of the Mid Term and the Final Score () Determine the Course Average and based on the Course Average, determine the Course Grade using the VLOOKUP function Using the Countif function determine the number of students getting each letter grade (le how many A's, B's etc.) Course Grading Scale Based on Course Average Lower Upper Course Limit Limit Grade 59 F 60 69 D 79 89 B 90 100 A 0 70 80 Course Average Course Grade 2898823 Last Name Alt Amini Amoako Apland Bachman Corder Desi Dransman Duffuor Finkel Foster Fuss George Gerson Girling Greer Guerro Hager Hellman Hibbard Hills Hughes Hutchison Jackson Kassner Kelcik Kern Kinner Lai Marsh Martini Mattiin McGough Miller Minnick Minster Mueller Munzo Nanko Owen Reth Rezai Ridder Rodgers Ruschau Schneider Schnirring Schwartz Scott Shaw Sims Steelman Trentman Villaris Wettee Weyer Whipky Willis Midterm Score 70 95 82 45 68 91 87 60 80 97 90 74 72 83 61 95 70 65 82 95 62 78 88 85 87 74 46 55 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 Final Score 56 91 78 45 98 74 80 93 98 91 82 92 76 66 100 77 93 94 57 93 95 100 90 B6 76 86 97 96 BB B4 78 80 93 67 93 94 96 78 86 100 79 97 90 96 93 81 76 87 68 79 72 B3 61 95 90 95 4:04 TikTok Done Assignment 2.xlsx a indicated below is the Coun Gating saho the Mand Schwed by atento the date of Ones The courte vragen en of iemande Frauere Determine the course rage and based on the course Average setemiere Course Grade ning the VLOOKUP Unction Using the Count function commune the number of studera geting each other adee how many AB Courte Grading Scan used on Course Average Usper Course Limit Lima Grade 0 30 60 TO YO c 10 ED 90 500 A Course Average Course Grade Last Name AH Amini Michem Score YO 95 2 Apland Bachman Corder 91 82 60 80 Desi Dransman Duur Finkel Foster Fuss Final Score 56 1 80 78 45 98 74 80 93 98 91 82 92 76 66 100 72 93 88 4 90 74 George Gerson Gring Groer Guero Hager Hellman Hibband His Hughes Hachon Jackson Kasse KR kom Kinner 95 70 65 82 95 62 78 88 85 93 95 100 90 74 45 55 90 88 78 86 97 Marsh Mart Man Medog 88 84 78 80 93 74 65 58 06 68 26 83 54 70 95 81 93 94 Narke 78 86 100 10 23 Milor Minnick Master M Marso Owen Reth New Rader Rodgers Ruchu Schneider Schwing Schwartz Scott Sh Sims Sleman Tretman Van Wittee Weyer Whipky Wie 93 13 81 1 YA 76 72 74 10 7 54 51 45 63 14 3 05 TB 64 90 88 90 68 20 72 61 95 90 95 Q. Indicated below is the Course Grading scale as also the Mid Term and Final Scores achieved by students in the class of OM 455, The course average is the average of the Mid Term and the Final Score () Determine the Course Average and based on the Course Average, determine the Course Grade using the VLOOKUP function Using the Countif function determine the number of students getting each letter grade (le how many A's, B's etc.) Course Grading Scale Based on Course Average Lower Upper Course Limit Limit Grade 59 F 60 69 D 79 89 B 90 100 A 0 70 80 Course Average Course Grade 2898823 Last Name Alt Amini Amoako Apland Bachman Corder Desi Dransman Duffuor Finkel Foster Fuss George Gerson Girling Greer Guerro Hager Hellman Hibbard Hills Hughes Hutchison Jackson Kassner Kelcik Kern Kinner Lai Marsh Martini Mattiin McGough Miller Minnick Minster Mueller Munzo Nanko Owen Reth Rezai Ridder Rodgers Ruschau Schneider Schnirring Schwartz Scott Shaw Sims Steelman Trentman Villaris Wettee Weyer Whipky Willis Midterm Score 70 95 82 45 68 91 87 60 80 97 90 74 72 83 61 95 70 65 82 95 62 78 88 85 87 74 46 55 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 Final Score 56 91 78 45 98 74 80 93 98 91 82 92 76 66 100 77 93 94 57 93 95 100 90 B6 76 86 97 96 BB B4 78 80 93 67 93 94 96 78 86 100 79 97 90 96 93 81 76 87 68 79 72 B3 61 95 90 95