Question: Q.5 (Bonus) solve using excel: (10 pts) Student Passed CVLE 101 CVLE102 Letter Grade RESIT GPA courses name Mostafa Jaffar Jhon Yahia Carol Beth Sara

Q.5 (Bonus) solve using excel: (10 pts) Student Passed CVLE 101 CVLE102 Letter Grade RESIT GPA courses name Mostafa Jaffar Jhon Yahia Carol Beth Sara Average 15 85 35 90 75 53 97 62 33 60 13 77 42 88 1. Calculate the average of the grades 2. Using if function determine the number of passed courses 3. Using if function determine the letter grade by calculating the average grade for each student and refer to the range given. 4. Using IF and referring to the letter grade determine the GPA (A=4.0;B=3.0;C=2.0;D=1.0;F=0) 5. Using if function determine if the student has resit exam by writing Yes or no Range OSGrade
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
