Scribd
Upload
7 views2 pages

Pivot Table Assignment Questions

The document outlines a Pivot Table assignment consisting of 30 questions aimed at analyzing sales data through various metrics. Tasks include calculating total sales by department, average unit prices, sales trends, and comparisons between regions and products. The assignment emphasizes the use of Pivot Tables to summarize and visualize sales information effectively.

Uploaded by

arindombhadury12
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
7 views2 pages

Pivot Table Assignment Questions

The document outlines a Pivot Table assignment consisting of 30 questions aimed at analyzing sales data through various metrics. Tasks include calculating total sales by department, average unit prices, sales trends, and comparisons between regions and products. The assignment emphasizes the use of Pivot Tables to summarize and visualize sales information effectively.

Uploaded by

arindombhadury12
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Pivot Table Assignment – 30 Questions

1. Create a Pivot Table to find total sales by each department.

2. Create a Pivot Table to show average unit price by product category.

3. Create a Pivot Table to display total units sold per region.

4. Create a Pivot Table to calculate total sales by month and region.

5. Create a Pivot Table to summarize total sales for each employee.

6. Create a Pivot Table to compare units sold of each product by department.

7. Create a Pivot Table to show the highest selling product by total sales.

8. Create a Pivot Table to find average units sold per month for each region.

9. Create a Pivot Table to group total sales by department and product.

10. Create a Pivot Table to display unit price range (min, max) per product.

11. Create a Pivot Table to calculate monthly sales trend by region.

12. Create a Pivot Table to create a pivot to count how many times each product was sold.

13. Create a Pivot Table to determine the top 3 departments by sales.

14. Create a Pivot Table to compare sales of North vs South regions.

15. Create a Pivot Table to analyze unit price trends across departments.

16. Create a Pivot Table to show quarterly sales summary by region.

17. Create a Pivot Table to calculate the average revenue per sale.

18. Create a Pivot Table to count how many employees sold more than 30 units.

19. Create a Pivot Table to identify the month with highest sales.

20. Create a Pivot Table to summarize total sales by employee and product.

21. Create a Pivot Table to group unit prices into ranges and count their frequencies.

22. Create a Pivot Table to display the department with highest total sales.

23. Create a Pivot Table to create a chart from the pivot showing product-wise sales.

24. Create a Pivot Table to compare sales in January vs July.


25. Create a Pivot Table to show average sales per unit across regions.

26. Create a Pivot Table to analyze how many products were sold above 1000 in value.

27. Create a Pivot Table to calculate the variance in total sales across months.

28. Create a Pivot Table to find correlation between units sold and total sale using pivot.

29. Create a Pivot Table to summarize employee-wise average units sold.

30. Create a Pivot Table to display sales heatmap by region and product.

You might also like