Question 1

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"

Question 2

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.

Question 3

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.

Question 4

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