Adele Wants to Extract a List of Unique Items in a Database.Which

question 47

Multiple Choice

Adele wants to extract a list of unique items in a database.Which of the following will she select in the series of clicks to do so: Select cell > Data tab > Advanced > Select option under Action (X) > Specify List range > Select a starting cell for copying to location > Check box beside Unique records only > OK?

• A) Filter the list,in place
• B) Copy to another location
• C) Filter unique records
• D) Copy unique records