Sort and Filter. Apply a sort and a filter to the table. Cell range B6:F29 Sort Column Zero Scores Order Largest to Smallest Column IDs Order Smallest to Largest Filter Hide students ids with no zero scores.

Rename a table. Cell range B6:F29 Name: "Overview"

Create a table and modify the table styles. Cell range B6:F29 Table Style Medium 4 Enable the First Column Style

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"

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 minimum homework score for each student. Cell range D7:D29 Number 1: minimum homework score for each student on "Section 3" worksheet.

Create a new named range. Cell range C7:C29. Name: "Homework"

Formula. Find the average of each student’s homework scores. Cell range C7:C29 Use Function AVERAGE Number 1: all homework for each student on "Section 3" worksheet "22-Aug 12-Dec"

Insert the instructor’s name for column B. Cell B5. Use Function RIGHT Text: B2 Absolute reference Num_chars: "16"

Crop the picture. Books.jpg Crop to Shape Snip Same Side Corner Rectangle.