Formula. Insert text using a formula Cell K2 Use Function CONCATENATE Text1 : "Students with no " Text 2: header of column F Absolute Reference

Create a chart. To the right of the data Chart 3-D Clustered Column Exclude all filtered rows Horizontal Axis Labels: "IDs" column in table Series 1: "Zero Scores" column in table.

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.