Explanation
Sort arranges data in a specific order, while Filter displays only the records that match selected conditions.
Sort examples:
- A to Z
- Z to A
- Smallest to Largest
- Largest to Smallest
- Oldest to Newest
Filter examples:
- Show only Sirsa customers
- Show Sales greater than ₹10,000
- Show only Accessories
- Show orders from a particular date
Example Data
|
Order ID |
Customer |
City |
Product |
Category |
Sales |
|
O101 |
Amit |
Sirsa |
Keyboard |
Accessories |
4000 |
|
O102 |
Neha |
Hisar |
Mouse |
Accessories |
5000 |
|
O103 |
Rahul |
Sirsa |
Monitor |
Hardware |
25500 |
|
O104 |
Priya |
Fatehabad |
Printer |
Hardware |
24000 |
|
O105 |
Amit |
Sirsa |
Keyboard |
Accessories |
4000 |
|
O106 |
Simran |
Hisar |
Webcam |
Accessories |
10000 |
Practice
Open the Data tab and identify the Sort & Filter group.