📊 CheckQuery Excel Practice Lab
Practice Excel formulas, functions, data analysis, MIS reporting and real-world job assignments. Learn → Practice → Check → Improve → Become Job Ready.
Your Excel Learning Progress
Complete exercises to improve your score.
0%
0
Attempted
0
Correct
0
Total Score
0
Current Streak
Starter
Learning Level
📌 Monthly Sales MIS Assignment
Prepare a management-ready analysis using the provided sales data.
- Calculate total sales.
- Calculate total quantity sold.
- Find the highest-selling region.
- Find the top salesperson.
- Calculate average sales.
- Calculate gross margin.
- Create a PivotTable.
- Prepare a monthly sales chart.
- Identify the top 5 products.
- Write three business insights.
| Date | Region | Salesperson | Product | Qty | Sales | Cost |
|---|---|---|---|---|---|---|
| 01-Sep | North | Ravi | Laptop | 4 | 240000 | 200000 |
| 03-Sep | South | Amit | Monitor | 8 | 160000 | 125000 |
| 06-Sep | North | Neha | Keyboard | 15 | 45000 | 30000 |
| 10-Sep | West | Priya | Laptop | 3 | 180000 | 150000 |
| 15-Sep | East | Amit | Mouse | 20 | 30000 | 18000 |
| 21-Sep | North | Ravi | Monitor | 5 | 100000 | 78000 |
Leave a reply