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
Share
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
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 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!