Question

What is an Excel feature that displays only the data in column(s) according to specified criteria?

• A. Filtering
• B. Sorting
• C. Formula
• D. Pivot

Hint:

Use the Filter feature in Excel to display data that meets specific criteria, making it easier to analyze large datasets.

Answer 1

The Correct Option is A

The Filtering feature in Excel allows users to display only the data in the specified column(s) that meet certain criteria. This is useful for narrowing down large datasets to focus on specific information.

Step 1: Understanding other options.
- (B) Sorting: Sorting organizes data in ascending or descending order but does not filter or hide data based on criteria. - (C) Formula: Formulas in Excel are used for calculations and do not filter or display data based on criteria. - (D) Pivot: Pivot tables summarize data, but they are not used specifically for filtering data based on criteria.

Step 2: Conclusion.
The correct feature for displaying data based on specific criteria is Filtering.

Final Answer: Filtering.