Question: A B F G H Ch24 Problem: The following data contains exam scores for students. The top 10 students receive an A, the next 20

A B F G H Ch24 Problem: The following data contains exam scores for students. The top 10 students receive an A, the next 20 students receive a B, and all other students receive a C. Highlight the A grades in red, the B grades in green, and the C grades in blue. Hint: The formula =LARGE(D4:D63,10) gives you the tenth highest grade on the test. 54 2 3 4 5 6 7 8 Student Grade 1 2 3 4 5 6 7 79 82 97 90 90 59 61 8 63 91 93 87 55 65 69 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 55 55 54 68 83 70 73 70 59 87 68 57 65 74 51 82 78 50 70 69 65
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
