In MS-Excel, _______ facilitates to specify some criterion in one or more columns to display selective data.

Question

Accepted Answer

The correct option is (3):
Filtering is the precise MS-Excel feature used to analyze and present a subset of a large dataset by applying specific conditions, or criteria, to one or multiple columns. This process, which can be achieved using either the simple AutoFilter or the complex Advanced Filter, works by temporarily hiding rows that do not meet the specified criteria (e.g., show only sales over $500 or only records from 'North' region). The core function of filtering is to specify a criterion and, based on that, **display selective data** without altering the underlying data structure, making it the perfect tool for viewing only the relevant rows in a structured list.

The incorrect option is (1):
A Formula in MS-Excel is fundamentally an expression that calculates a value in a cell, such as =SUM(A1:A10) or =IF(B2\>100, "High", "Low"). While newer functions like the FILTER dynamic array function can return a subset of data, a formula by itself does not facilitate the specification of criteria to directly hide or display rows across the entire sheet, which is the mechanism described. Its primary role is computation and manipulation of values within cells or ranges, not the overall display management of rows in a worksheet. Therefore, the term "Formula" describes the means of calculation, not the feature for selective data display.

The incorrect option is (2):
Sorting is the process of arranging data records in a particular sequence, typically in ascending (A to Z) or descending (Z to A) order based on the values in one or more columns. The purpose of sorting is to organize the entire dataset for better readability or to group similar values together. Crucially, sorting does not **selectively display data**; it changes the *order* of all rows but keeps every single row visible. Since the question asks for a facility that displays *selective* data (a subset of rows), sorting is incorrect as it deals with arrangement, not selection and concealment.

The incorrect option is (4):
A PivotTable is a powerful data summarization tool that aggregates data from a source range or table and presents it in a new, condensed, and interactive report format. Its main objective is to calculate totals, averages, and counts for different categories, often in a cross-tabular structure. While it uses criteria to group and summarize data, it is a reporting tool that creates a **new summarized table**, which is different from simply displaying a selective view of the original raw data by hiding unwanted rows, which is the function of filtering.