Sort and Filter.Apply a sort and a filter to the table.Cell range B6:F29 -Sort -Column Zero Scores Order Largest to SmallestColumn IDs Order Smallest to LargestFilter -Hide students ids with no zero scores.
Create a chart.To the right of the data -Chart 3-D Clustered Column -Exclude all filtered rows -Horizontal Axis Labels: "IDs" column in tableSeries 1: "Zero Scores" column in table.
Apply a style to the chart.Chart.Chart Styles Style 7 -
Rename the title of the chart.Chart -Text "All Zero Scores"
Formula.Insert text using a formula -Cell K2 -Use Function CONCATENATE -Text1 : "Students with no "Text 2: header of column F -Absolute Reference -
Add a worksheet -After other worksheets -Rename "Section 5"
