1 Start Excel . Download and open the file 0.000 namedexploring _ e02 _ grader _ h4 . xlsx .
2 In the range A7 : B9 in the Documentation sheet , enter
3.000 the breakpoints for the C grades . In row 7 , enter 70 as the breakpoint for C- ; in row 8 , enter 73 as the breakpoint for C ; and in row 9 , enter 77 as the breakpoint for C + .
3 Assign the name Grades to the range A3 : B14 in the 4.000
Documentation sheet .
4 In cell R3 of the Grades sheet , calculate the total lab
9.000 points earned for the first student in the Grades worksheet . Lab assignments are indicated by the column labels L1 through L10 . Copy the function to the range R4 : R21 .
5 In cell U3 of the Grades sheet , calculate the average of 9.000 the two midterm tests for the first student . Midterm tests