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.