The Grade 1 File has the grades of the students calculated for the following category weighting:Category WeightExam 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.
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here