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
Question & Answer
Which of the following is NOT a function of Excel’s Auto Filter feature?
1 Answer
Verified archiveThe correct answer is B. Removing duplicate rows.
Excel’s Auto Filter feature allows users to view subsets of data (A), apply dynamic filters (C), and sort data (D). However, it does not remove duplicate rows; that function is managed by the “Remove Duplicates” feature in Excel, which is a separate functionality. If you need further clarification or assistance on this topic, feel free to ask!