Which of the following features of MS Excel displays the data in column(s) according to criteria?

Correct option is D

The Filtering feature in MS Excel is used to display specific data in columns based on set criteria. It hides the rows that do not meet the criteria, allowing users to focus only on the relevant information.

Important Key Points:

1. Filtering temporarily hides data that does not meet the specified conditions, making data analysis easier.
2. Filters can be applied to text, numbers, and dates, and allow multiple conditions simultaneously.
3. Filtering does not modify the original data; it simply displays a subset of it.

Knowledge Booster:

1. Searching: Helps locate specific data within the worksheet but does not organize or filter it.
2. Sorting: Rearranges data in ascending or descending order but does not hide rows.
3. Pivot Table: Summarizes and analyzes data but is used for more complex data manipulations than filtering.
4. Advanced Filter: A feature in MS Excel that enables custom criteria for complex filtering scenarios.