Microsoft Excel Grader HW

I need help with this Excel homework involving pivot tables and formulas.