File Name
Sort_Filter_Practice.xlsx
Dataset
|
Order ID |
Date |
Customer |
City |
Product |
Category |
Qty |
Price |
Sales |
|
O101 |
01-Sep-26 |
Amit |
Sirsa |
Keyboard |
Accessories |
5 |
800 |
4000 |
|
O102 |
02-Sep-26 |
Neha |
Hisar |
Mouse |
Accessories |
10 |
500 |
5000 |
|
O103 |
03-Sep-26 |
Rahul |
Sirsa |
Monitor |
Hardware |
3 |
8500 |
25500 |
|
O104 |
04-Sep-26 |
Priya |
Fatehabad |
Printer |
Hardware |
2 |
12000 |
24000 |
|
O105 |
05-Sep-26 |
Amit |
Sirsa |
Keyboard |
Accessories |
5 |
800 |
4000 |
|
O106 |
06-Sep-26 |
Simran |
Hisar |
Webcam |
Accessories |
4 |
2500 |
10000 |
|
O107 |
07-Sep-26 |
Riya |
Sirsa |
Mouse |
Accessories |
8 |
500 |
4000 |
|
O108 |
08-Sep-26 |
Mohit |
Hisar |
Monitor |
Hardware |
2 |
8500 |
17000 |
|
O109 |
09-Sep-26 |
Kavita |
Fatehabad |
Keyboard |
Accessories |
6 |
800 |
4800 |
|
O110 |
10-Sep-26 |
Ankit |
Sirsa |
Printer |
Hardware |
1 |
12000 |
12000 |
Tasks
Task 1 — Basic Sorting
- Customer A to Z
- Sales Largest to Smallest
- Date Oldest to Newest
Task 2 — Multi-Level Sorting
- City A to Z
- Sales Largest to Smallest
Task 3 — Text Filtering
- City = Sirsa
- Product = Keyboard
- Category = Hardware
Task 4 — Number Filtering
- Sales > ₹10,000
- Sales < ₹5,000
- Sales between ₹5,000 and ₹20,000
Task 5 — Multiple Filters
Create:
Sirsa + Accessories + Sales ≥ ₹4,000
Task 6 — Final Report
Create a filtered sales report showing:
Order ID | Customer | City | Product | Sales
Sort Sales from Largest to Smallest.