Carmen Filtered a Table on the Values in the Department

question 563

Multiple Choice

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.