Question & Answer

Which of the following is NOT a function of Excel’s Auto Filter feature?

Which of the following is NOT a function of Excel’s Auto Filter feature? A. Viewing subsets of data

B. Removing duplicate rows

C. Applying dynamic filters

D. Sorting data

1 Answer

Verified archive
Quizzma TeamJune 16, 2025

The correct answer is B. Removing duplicate rows.

Excel’s Auto Filter feature is primarily used for viewing subsets of data, applying dynamic filters, and sorting data. However, it does not have the function of removing duplicate rows; that task is typically accomplished using the “Remove Duplicates” feature in Excel. If you have more questions or need further assistance, feel free to ask!