MO-211 practice question 10 of 35

How can you remove a filter applied to a column in Excel?

Full set: 355 questions

Domain Insert tables, charts, SmartArt, 3D models, and media

Answer options
A: Use the “Clear” function Correct answer
B: Use the “Advanced Filter” function
C: Use the “Sort” function
D: Use the “Find and Replace” function
Correct Answer:
A. Use the “Clear” function
Explanation

The most direct method to remove a filter applied to a column or an entire dataset in Excel is by using the "Clear" command. This command is located on the Data tab within the Sort & Filter group. When a filter is active, clicking "Clear" removes all filtering criteria from the current data range or table, making all rows visible again. This function is specifically designed for this purpose, distinguishing it from other data manipulation tools.

Why Incorrect

B. Use the “Advanced Filter” function: The "Advanced Filter" is used for applying complex criteria from a separate criteria range, not for clearing existing simple filters.
C. Use the “Sort” function: The "Sort" function is used to arrange data in a specific order (e.g., alphabetically or numerically) and does not remove filter criteria.
D. Use the “Find and Replace” function: This tool is for locating and changing cell contents and has no functionality related to applying or removing data filters.

References

1. Microsoft Corporation. (n.d.). Filter data in a range or table. Microsoft Support. Retrieved from https://support.microsoft.com/en-us/office/filter-data-in-a-range-or-table-01832226-31b5-4568-8806-38c37dcc180e.

Reference Point: Under the section "Clear a filter

" the document states

"To remove all filters from a worksheet

on the Data tab

in the Sort & Filter group

click Clear."

2. University of Wisconsin-Madison

Division of Information Technology (DoIT). (2016). Excel 2016: Filtering Data. Software Training for Students.

Reference Point: In the section "Clearing Filters

" the guide instructs: "To clear all filters from a worksheet

click the Data tab

then click the Clear button in the Sort & Filter group."

3. GCFGlobal.org. (n.d.). Excel: Filtering Data. Goodwill Community Foundation

Inc. Retrieved from https://edu.gcfglobal.org/en/excel/filtering-data/1/.

Reference Point: In the lesson on filtering

under the subsection "To clear a filter

" it states: "You can also click the Clear command on the Data tab to remove all filters from your worksheet."

Scroll to Top