Which feature lets you display only the rows that meet defined conditions?

Which feature lets you display only the rows that meet defined conditions?

• A. Hide
• B. Sort
• C. Group
• D. Filter

Answer: (D)

Filtering lets you display only the rows that meet defined conditions. You set criteria for one or more columns, and the view updates to show just the rows that satisfy those criteria. You can combine conditions with AND to require multiple criteria, or OR to allow any of several criteria. For example, filtering for country equals Canada and last purchase after 2024-01-01 shows only those matching rows. Sorting changes the order of rows, grouping organizes rows into categories for summaries, and hiding simply conceals rows rather than presenting a subset based on specific conditions.

Filtering lets you display only the rows that meet defined conditions. You set criteria for one or more columns, and the view updates to show just the rows that satisfy those criteria. You can combine conditions with AND to require multiple criteria, or OR to allow any of several criteria. For example, filtering for country equals Canada and last purchase after 2024-01-01 shows only those matching rows. Sorting changes the order of rows, grouping organizes rows into categories for summaries, and hiding simply conceals rows rather than presenting a subset based on specific conditions.