Question:medium

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

Show Hint

Use the Filter feature in Excel to display data that meets specific criteria, making it easier to analyze large datasets.
Updated On: May 7, 2026
  • Filtering
  • Sorting
  • Formula
  • Pivot
Show Solution

The Correct Option is A

Solution and Explanation

Let's define the Excel features mentioned:
(A) Filtering: This feature allows you to temporarily hide rows that you don't want to see and display only the rows that meet a specific criteria you define. This exactly matches the description in the question.
(B) Sorting: This feature arranges the data in a range or table in a specific order (e.g., alphabetically A-Z, or numerically from smallest to largest). It reorders the data but does not hide any of it.
(C) Formula: A formula is an expression that calculates the value of a cell (e.g., =SUM(A1:A5)).
(D) Pivot Table: A Pivot Table is an advanced tool used to summarize, analyze, and explore large amounts of data.
The feature that displays only the data meeting a specified criteria is Filtering.
Was this answer helpful?
0