File Name
Consolidate_Practice.xlsx
Create three worksheets.
Sheet 1 — Sirsa
|
Product |
Sales |
|
Keyboard |
4000 |
|
Mouse |
5000 |
|
Monitor |
25500 |
|
Printer |
12000 |
|
Webcam |
10000 |
Sheet 2 — Hisar
|
Product |
Sales |
|
Keyboard |
6000 |
|
Mouse |
4500 |
|
Monitor |
17000 |
|
Printer |
15000 |
|
Webcam |
9000 |
Sheet 3 — Fatehabad
|
Product |
Sales |
|
Keyboard |
4800 |
|
Mouse |
5500 |
|
Monitor |
24000 |
|
Printer |
12000 |
|
Webcam |
7500 |
Sheet 4 — Consolidated Report
Create:
|
Product |
Sirsa |
Hisar |
Fatehabad |
Total Sales |
|
Keyboard |
||||
|
Mouse |
||||
|
Monitor |
||||
|
Printer |
||||
|
Webcam |
Tasks
- Consolidate branch sales using SUM.
- Calculate Total Sales.
- Calculate Average Sales.
- Identify Maximum Sales.
- Identify Minimum Sales.
- Format the final report professionally.
- Create a chart from the consolidated data.
Final Challenge
Prepare a Multi-Branch Sales Dashboard Sheet showing:
- Branch-wise sales
- Product-wise sales
- Total sales
- Average sales
- Highest sales
Lowest sales