What is the correct way to apply data filters to show rows that meet specific criteria?

What is the correct way to apply data filters to show rows that meet specific criteria?

• A. Data > Filter, then specify criteria
• B. Home > Sort, then apply order
• C. Review > Protect, then set permissions
• D. Insert > Filter, then create a chart

Answer: (A)

Filtering data hides rows that don’t meet your conditions and shows only those that do. To do this, turn on filters in the Data area (Data > Filter). Once filters are active, use the drop-down arrow in the column you want to filter and specify your criteria (for example, show rows where a status column equals “Approved” or where a date is within a certain range). You can apply multiple criteria across different columns to further narrow the results. This approach directly targets which rows are visible based on your conditions. Other options don’t achieve the same result. Sorting changes the order of rows but doesn’t hide any, so all data remains visible. Protecting sets permissions and doesn't filter data. Inserting a filter path isn’t the standard way to apply filters.

Filtering data hides rows that don’t meet your conditions and shows only those that do. To do this, turn on filters in the Data area (Data > Filter). Once filters are active, use the drop-down arrow in the column you want to filter and specify your criteria (for example, show rows where a status column equals “Approved” or where a date is within a certain range). You can apply multiple criteria across different columns to further narrow the results. This approach directly targets which rows are visible based on your conditions.

Other options don’t achieve the same result. Sorting changes the order of rows but doesn’t hide any, so all data remains visible. Protecting sets permissions and doesn't filter data. Inserting a filter path isn’t the standard way to apply filters.