Carmen filtered a table on the values in the Department column and now wants to clear the filter.What can she do? Select all the options that apply.
A) Click the Sort & Filter button on the Home tab, then click Clear.
B) Click the Department arrow, then click Clear Filter from "Department".
C) Click the Filter Button check box on the Table Tools Design tab.
D) Right-click a cell in the Department column, then click Clear Contents on the shortcut menu.

Question

Quizplus · Accepted Answer

Carmen can clear the filter by using the Sort & Filter button on the Home tab and selecting Clear, or by clicking the Department arrow and selecting Clear Filter from "Department".

Carmen Filtered a Table on the Values in the Department