Which action clears the filter from the Category column?

Which action clears the filter from the Category column?

• A. Data tab, Sort & Filter group, Clear Filter
• B. Data tab, Sort & Filter group, Clear
• C. Home tab, Styles group, Clear Formats
• D. Review tab, Changes group, Clear

Answer: (B)

Clearing filters in Excel is done from the Data tab, in the Sort & Filter group, by selecting the Clear option. This removes any active filtering on the worksheet, so the Category column (and any other columns) shows all rows again. The Clear command resets the filter criteria across the sheet, not just for one column, which is why it’s the correct way to remove the filter from the Category column. The other options don’t fit: Clear Formats would remove cell formatting, not filters; Clear in the Review area deals with tracked changes or comments, not filters; and the phrase Clear Filter doesn’t correspond to the standard button in that group.

Clearing filters in Excel is done from the Data tab, in the Sort & Filter group, by selecting the Clear option. This removes any active filtering on the worksheet, so the Category column (and any other columns) shows all rows again. The Clear command resets the filter criteria across the sheet, not just for one column, which is why it’s the correct way to remove the filter from the Category column.

The other options don’t fit: Clear Formats would remove cell formatting, not filters; Clear in the Review area deals with tracked changes or comments, not filters; and the phrase Clear Filter doesn’t correspond to the standard button in that group.