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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!