Advanced Excel Mock Exam

As an administrative assistant at a multinational corporation, you are responsible for preparing financial reports and conducting analyses to support decision-making processes. Your supervisor has tasked you with completing an advanced Excel exam to assess your proficiency in using Excel for financial analysis and reporting.

Task 1

a) Import the dataset into Excel.

b) Calculate the total sales revenue for each product category for each year using PivotTables.

c) Create a PivotChart to visualize the sales trends over the years for all product categories.

Task 2

1. Analyze the survey data to identify trends and patterns in customer satisfaction levels.

2. Create a dashboard in Excel to visualize the survey results, including charts and graphs to represent satisfaction scores by demographic factors (e.g., age, gender, location).

3. Provide insights and recommendations based on the analysis to improve customer satisfaction and retention.

Submit your answer to