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