Formula.Find the minimum homework score for each student.Cell range D7:D29 -Number 1: minimum homework score for each student on "Section 3" worksheet.
Formula.Find the maximum homework score for each student.Cell range E7:E29 -Use Function MAX -Number 1: maximum homework score for each student on "Section 3" worksheet.
Formula.Count the number of 0 homework scores for each student.Cell range F7:F29 -Use function COUNTIF -Range: all possible homework scores for each student on "Section 3" worksheet.Criteria: 0 -
Formula -Find the average score of all student ids without a zero homework score.Cell L2 -Use Function AVERAGEIF -Range F7:F29 -Criteria: "0"Average_range: "Homework"
Create a table and modify the table styles.Cell range B6:F29 -Table Style Medium 4 -Enable the First Column Style -
Rename a table.Cell range B6:F29 -Name: "Overview"
