Question

An ASO has a list of 500 employees in Excel with names in column A and dates of joining in column B. She wants to arrange the list by date of joining. Which feature should she use?

1.
Freeze panes at column B
2.
Sort the data by column B
3.
Filter the data by column B
4.
Merge cells in column B
Answer (Detailed Solution Below)

Option 2 : Sort the data by column B

🪔
DIWALI BIGGEST SALE EVER LIVE

All Major Govt. Exams — One Stop Preparation

Unlimited Tests, 2,500+ PYPs & AI All-India Ranking.

SSC & Railway Exams
Teaching & State Exams
All India Live Ranking
2,500+ Solved PYPs

Festive Offer Live • Instant Activation

Advertisement

Detailed Solution

सही उत्तर Sort the data by column B है।

Key Points

The Sort feature arranges the rows of a list in order on the basis of a chosen column, here the date of joining in column B.

Helpful?
Latest Exam & Job Updates
Last updated on Oct 26, 2026

Recommended Test Series

Attempt full-length mock tests, sectional papers & All India Rank

Explore All
NEW
Nursing, AIIMS & Madical Exams

AIIMS CRE Social Security Officer, Manager Grade-II & Superintendent Test Series 2026

PREPSNAP STUDY
AIIMS CRE Social Security Officer, Manager Grade-II & Superintendent Test Series 2026 Logo

AIIMS CRE Social Security Officer, Manager Grade-II & Superintendent Test Series 2026

0.4k Users

20 Total Tests


English, Hindi
  • •20 Full Test (Prelims)
SSC Exams

SSC GD Constable Test Series

PREPSNAP STUDY
SSC GD Constable Test Series Logo

SSC GD Constable Test Series

7.5k Users

145 Total Tests


English, Hindi
  • •15 Full Test (Prelims)
  • •50 Sectional Test
  • •55 Chapter Test
  • +25 more tests
NEW
DSSSB

DSSSB Junior Scientific Assistant (LieDetection) Test Series 2026 | 25+ Mock Tests

PREPSNAP STUDY
DSSSB Junior Scientific Assistant (LieDetection) Test Series 2026 | 25+ Mock Tests Logo

DSSSB Junior Scientific Assistant (LieDetection) Test Series 2026 | 25+ Mock Tests

2.5k Users

120 Total Tests


English, Hindi
  • •20 Full Test (Prelims)
  • •100 Sectional Test
NEW
Nursing, AIIMS & Madical Exams

AIIMS CRE Assistant Security Officer Test Series 2026

PREPSNAP STUDY
AIIMS CRE Assistant Security Officer Test Series 2026 Logo

AIIMS CRE Assistant Security Officer Test Series 2026

0.4k Users

70 Total Tests


English, Hindi
  • •20 Full Test (Prelims)
  • •50 Sectional Test

More Domain-Specific Questions

PrepSnapprepsnap.in • Domain-Specific

Question:

An ASO has a list of 500 employees in Excel with names in column A and dates of joining in column B. She wants to arrange the list by date of joining. Which feature should she use?

1.
Freeze panes at column B
2.
Sort the data by column B
3.
Filter the data by column B
4.
Merge cells in column B

Correct Answer: Sort the data by column B

The Sort feature arranges the rows of a list in order on the basis of a chosen column, here the date of joining in column B.

Downloaded from PrepSnap (prepsnap.in)