The Grade 1 File has the grades of the students calculated for the following category weighting: Category Weight Exam 50% Excel 35% Quizzes 15% You are to copy the information into a new worksheet,...

The Grade 1 File has the grades of the students calculated for the following category weighting:

Category Weight
Exam 50%
Excel 35%
Quizzes 15%


You are to copy the information into a new worksheet, label it Grade 2 and change the category weighting to the following:

Exam 25%
Excel 55%
Quizzes 20%


Use a Vlookup to put the percentage grade in the column labeled Grade 2 in the Grade 1 Worksheet.

Use an If function to give the student the highest percentage.

Use a Vlookup to give the students a letter grade based on a 90% for A, 80% for B, 70% for C, 60% for D, F for all below 60%..

What is the grade distribution (i.e., number of A, B, C, D, and F).

If we want the top 20% of the students to get an A, what must the percentage be changed to for getting an A.