are indicated by the column labels M1 and M2 . Copy the function to the range U4 : U21 .
6 In cell G3 of the Grades sheet , calculate the assignment
9.000 average for the first student . Assignments are indicated by the column labels A1 through A5 . The formula should drop the lowest score before calculating the average using a combination of SUM , MIN , and COUNT . The argument for each function for the first student is B3 : F3 . Find the total points ( SUM ) and subtract the lowest score ( MIN ) from the result . Then divide the remaining points by the number of assignments ( COUNT ) minus 1 . Copy the formula to the range G4 : G21 .
7 In cell W3 of the Grades sheet , calculate the weighted
6.000 total points based on the four category points ( assignment average , lab points , midterm average , and final exam , in that order ) and their respective weights ( stored in the range B30 : B33 ). Use relative and absolute