INSTRUCTIONS: "Solve all questions using excel functions and the excel data analysis pack"

Can someone help me by going through what I need to put in terms of the functions/ answering these - I have absolutely no idea what I'm doing. Please explain in a detailed and simple manner - I have never done stats via excel before.

A C D E H 01 5 Marks The table below indicate the norm for students grades in MGSC 301. 4 Grade Excellent Very Good Good Accepted Fail 5 Proportion of Students 0.4 0.3 0.15 0.1 0.05 Q1 The new cohort of 75 students in MGSC 301 indicated the following results: 9 Grade Excellent Very Good Good Accepted Fail 10 Number of Students 31 23 12 2 11 12 Using p - .05, does the actual rating of the new cohort deviate significantly 13 from the norm in MGSC 301? 10