Question 2 [24] A local university has received funding from the government to build a new block for lectures. They have provided you with the following enrolment information. You are to determine which courses have the most significant number of enrolments. You are to present your findings to the university management, but the allocated time for the presentation is short. You have decided to showcase your skills by using visualisations to analyse data. Answer the following questions. Note to grader: Please check the submitted Excel file where a student did not add a screenshot. 2.1 Calculate the total enrolment for the university. (2 marks) 2.2 Calculate the total payments for the courses. (4 marks) 2.3 Create a column chart showing the enrolment for each course. Include the enrolment figures in the chart. (2 marks) 2.4 Show the enrolment figures and courses in a pie chart. (2 marks) 2.5 Create a labelled 3D pie chart for your answer to question Q.2.4. (2 marks) 3 HCLT108-1-Jan-June2023-FA1--IM-V,4-17022023 2.6 Create a combo chart showing enrolment and total payment figures. (3 marks) If each student is required to pay a 25000 deposit at the beginning of the semester, answer the following questions. 2.6 Calculate the total amounts of fees paid as deposits. (3 marks) 2.7 Calculate the total outstanding fees after every student has paid the required deposit. (3 marks) 2.8 Create a column chart showing the outstanding fees per course