Which of the following option in MS-Excel 365 refers to display only rows that meet certain conditions?

Question

Question

This question was previously asked in

Delhi Police Constable: Memory Based Test (Held on: 21 November 2023 Shift 1)

Answer 1

The correct answer is Filtering

Key Points

Filtering: Filtering in Excel gives you the ability to display only rows that meet certain conditions, and hide rows that do not. This helps when looking at data on a specific subset of your data.
For example, if you have a column of data indicating 'Status' with values of 'Open' or 'Closed', you could filter for 'Open' to only display rows where the status is 'Open'.

Additional Information

Merging: This refers to the process of combining two or more cells into a single cell. This can be particularly useful for formatting, such as when you want to create a single title cell over a particular group of cells.
Pivoting: This term usually refers to PivotTables in Excel. A PivotTable is a dynamic table that summarizes a large amount of data, allowing you to manipulate and analyze it in different ways. You can "pivot" the table by rotating its columns into rows (or vice versa) to see different summaries of the source data.
Sorting: In Excel, you can sort data in a range of cells or table. This means arranging data alphabetically from A to Z or Z to A, numerically from smallest to largest or largest to smallest, and by date or time from oldest to newest or newest to oldest.