KEMBAR78
Sales Table | PDF
Scribd
Upload
209 views1 page

Sales Table

The document outlines sales data for various products sold by different salespersons across regions in January 2025. It includes specific sales figures, unit prices, and total sales, and poses several pivot table and chart-based questions for analysis. The questions focus on total sales by region, units sold by product, salesperson performance, and visual representations of the data.

Uploaded by

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

Sales Table

The document outlines sales data for various products sold by different salespersons across regions in January 2025. It includes specific sales figures, unit prices, and total sales, and poses several pivot table and chart-based questions for analysis. The questions focus on total sales by region, units sold by product, salesperson performance, and visual representations of the data.

Uploaded by

Abhinav Singh
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

Date Region Salesperson Product Units Sold Unit Price Total Sales

2025-01-05 North Raj Laptop 3 50000 150000


2025-01-08 South Priya Tablet 5 20000 100000
2025-01-10 East Amit Smartphone 10 15000 150000
2025-01-11 West Neha Laptop 2 50000 100000
2025-01-15 North Raj Tablet 4 20000 80000
2025-01-18 South Priya Smartphone 7 15000 105000
2025-01-20 East Amit Laptop 1 50000 50000
2025-01-22 West Neha Tablet 6 20000 120000
2025-01-25 North Raj Smartphone 8 15000 120000
2025-01-28 South Priya Laptop 2 50000 100000

✅ Pivot Table-Based Questions

1. Total Sales by Region


Create a pivot table to calculate total sales in each region.
2. Total Units Sold by Product
Find out how many units of each product were sold.
3. Salesperson Performance
Use a pivot table to show total sales made by each salesperson.
4. Product Sales per Region
Which region sold the highest number of Laptops?
5. Average Sales per Product
What is the average total sale amount per product type?
6. Salesperson vs. Product Analysis
Create a pivot table to show how many units of each product were sold by each
salesperson.
7. Monthly Sales Trend
Group dates by month in a pivot table and show total sales month-wise.

Chart-Based Questions

1. Create a Column Chart


Show total sales per region using a column chart.
2. Create a Pie Chart
Display percentage contribution of each product to the total sales.
3. Create a Line Chart
Plot total sales over time to visualize the trend.
4. Bar Chart Comparison
Compare sales between Raj and Priya using a bar chart.
5. Stacked Column Chart
Show product-wise sales distribution across different regions.

You might also like