Question

Which option in MS-Excel is used to arrange data in ascending or descending order?

• A. Filter
• B. Sort
• C. Format
• D. Arrange

Hint:

Sort = Rearrange Data.
Filter = Show Specific Data.

Answer 1

The Correct Option is B

Concept: Microsoft Excel provides several tools for organizing and analyzing data. One of the most commonly used features is sorting, which allows users to arrange data in a meaningful sequence.

Step 1: Understand sorting. Sorting rearranges records according to specified criteria. Examples include:

• Alphabetical order (A to Z).

• Reverse alphabetical order (Z to A).

• Numerical order (smallest to largest).

• Numerical order (largest to smallest).

• Date order.

Step 2: Role of Sort option. The Sort feature automatically reorganizes selected data according to chosen rules. This makes data analysis easier and improves readability.

Step 3: Analyze the other options. Filter is used to display selected records while hiding others. Format changes appearance. Arrange is not the standard Excel command used for ascending or descending order.

Step 4: Conclusion. Therefore, the Sort option is used to arrange data in ascending or descending order. Hence, option (B) is correct.