Adele wants to filter a Customers table to show customers in Denver or customers with invoices over $2500. What type of filter should she use?
A) Number AutoFilter
B) Advanced filter
C) Text with wildcard filter
D) Date AutoFilter

Question

Quizplus · Accepted Answer

Adele should use the advanced filter option, which allows for multiple criteria to be used in the filtering process. She can set one criterion for customers in Denver and another for invoices over $2500. This will give her the desired results. The other filter options listed are not suitable for these criteria.

Adele Wants to Filter a Customers Table to Show Customers