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
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
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!