How do you filter data in a table?

How do you filter data in a table?

• A. Data tab -> Filter; click filter arrows to apply criteria
• B. Home tab -> Sort; use arrows to filter
• C. Data tab -> Sort; apply criteria
• D. Review tab -> Filter; apply criteria

Answer: (A)

Filtering a table means showing only the rows that meet certain criteria by turning on AutoFilter. The best way is to go to the Data tab and click Filter; this adds dropdown arrows to each column header. Click the arrow in the column you want to filter and choose the criteria you need, and only matching rows remain visible. This differs from sorting, which just rearranges rows without hiding anything. The other tabs don’t provide the filtering command, so enabling Filter on the Data tab is the correct first step.

Filtering a table means showing only the rows that meet certain criteria by turning on AutoFilter. The best way is to go to the Data tab and click Filter; this adds dropdown arrows to each column header. Click the arrow in the column you want to filter and choose the criteria you need, and only matching rows remain visible. This differs from sorting, which just rearranges rows without hiding anything. The other tabs don’t provide the filtering command, so enabling Filter on the Data tab is the correct first step.