ASSIGNMENT – 28 — ANSWER KEY
Create Pivot Table Using Data
Total Data Records: 18
Q.1 — Month-wise Total Sales
Create Pivot Table:
Rows: Month
Values: Sum of Sales Amount
| Month | Total Sales |
|---|---|
| January | ₹1,17,450 |
| February | ₹1,64,950 |
| March | ₹2,26,050 |
| April | ₹1,81,450 |
| Grand Total | ₹6,89,900 |
Answer:
-
January = ₹1,17,450
-
February = ₹1,64,950
-
March = ₹2,26,050
-
April = ₹1,81,450
-
Grand Total = ₹6,89,900
Q.2 — Month-wise Average Sales
Rows: Month
Values: Average of Sales Amount
| Month | Average Sales |
|---|---|
| January | ₹29,362.50 |
| February | ₹32,990.00 |
| March | ₹45,210.00 |
| April | ₹45,362.50 |
Answer:
Highest Average Sales = April — ₹45,362.50
Q.3 — Month-wise Number of Sales Transactions
Rows: Month
Values: Count of Sales Amount
| Month | Number of Transactions |
|---|---|
| January | 4 |
| February | 5 |
| March | 5 |
| April | 4 |
| Grand Total | 18 |
Answer:
Total Transactions = 18
Q.4 — Date-wise Total Sales
Rows: Date of Sale
Values: Sum of Sales Amount
| Date of Sale | Total Sales |
|---|---|
| 05-01-2026 | ₹25,000 |
| 12-01-2026 | ₹32,500 |
| 18-01-2026 | ₹18,750 |
| 25-01-2026 | ₹41,200 |
| 03-02-2026 | ₹22,500 |
| 09-02-2026 | ₹35,800 |
| 15-02-2026 | ₹28,400 |
| 21-02-2026 | ₹46,500 |
| 27-02-2026 | ₹31,750 |
| 04-03-2026 | ₹52,000 |
| 10-03-2026 | ₹38,500 |
| 16-03-2026 | ₹44,250 |
| 22-03-2026 | ₹29,800 |
| 28-03-2026 | ₹61,500 |
| 05-04-2026 | ₹35,000 |
| 12-04-2026 | ₹48,500 |
| 18-04-2026 | ₹42,750 |
| 25-04-2026 | ₹55,200 |
| Grand Total | ₹6,89,900 |
Q.5 — Highest Sales Amount
From the Pivot Table:
Answer:
Highest Sales Amount = ₹61,500
Date:
28-03-2026
Q.6 — Lowest Sales Amount
Answer:
Lowest Sales Amount = ₹18,750
Date:
18-01-2026
Q.7 — Total Sales of January and February
January
₹1,17,450
February
₹1,64,950
| Month | Total Sales |
|---|---|
| January | ₹1,17,450 |
| February | ₹1,64,950 |
Q.8 — Total Sales of March and April
March
₹2,26,050
April
₹1,81,450
| Month | Total Sales |
|---|---|
| March | ₹2,26,050 |
| April | ₹1,81,450 |
Q.9 — Month-wise Sales Sorted Highest to Lowest
Create:
Rows: Month
Values: Sum of Sales Amount
Then sort Largest to Smallest.
| Rank | Month | Total Sales |
|---|---|---|
| 1 | March | ₹2,26,050 |
| 2 | April | ₹1,81,450 |
| 3 | February | ₹1,64,950 |
| 4 | January | ₹1,17,450 |
Answer:
Highest Sales Month = March
Lowest Sales Month = January
Q.10 — Complete Month-wise Sales Analysis
Add Sales Amount three times in the Values area:
-
Sum
-
Average
-
Count
| Month | Sum of Sales | Average of Sales | Count of Sales |
|---|---|---|---|
| January | ₹1,17,450 | ₹29,362.50 | 4 |
| February | ₹1,64,950 | ₹32,990.00 | 5 |
| March | ₹2,26,050 | ₹45,210.00 | 5 |
| April | ₹1,81,450 | ₹45,362.50 | 4 |
| Grand Total | ₹6,89,900 | ₹38,327.78 | 18 |
Final Answers
1. Highest Sales Month:
➡️ March — ₹2,26,050
2. Lowest Sales Month:
➡️ January — ₹1,17,450
3. Highest Average Sales Month:
➡️ April — ₹45,362.50
4. Total Number of Transactions:
➡️ 18
⭐ Final Answer Summary
| Q. | Answer |
|---|---|
| Q.1 | January ₹1,17,450; February ₹1,64,950; March ₹2,26,050; April ₹1,81,450 |
| Q.2 | January ₹29,362.50; February ₹32,990; March ₹45,210; April ₹45,362.50 |
| Q.3 | Jan 4, Feb 5, Mar 5, Apr 4 |
| Q.4 | Grand Total ₹6,89,900 |
| Q.5 | Highest = ₹61,500 |
| Q.6 | Lowest = ₹18,750 |
| Q.7 | January ₹1,17,450; February ₹1,64,950 |
| Q.8 | March ₹2,26,050; April ₹1,81,450 |
| Q.9 | March → April → February → January |
| Q.10 | Highest Sales: March; Lowest Sales: January; Highest Average: April; Transactions: 18 |