Case EX 9-2 Matt runs a local cat shelter. He uses an Excel workbook to store information about the various cats residing at the shelter. If Matt needs to only display the information about male cats who are older than 3 years, he can use a ____.
A) Conditional Format
B) Custom AutoFilter
C) Universal Search
D) Banded search

Question

Quizplus · Accepted Answer

Matt can use a Custom AutoFilter to display information about male cats who are older than 3 years by applying filters on the "Gender" and "Age" columns. Conditional Formatting is used for highlighting specific values or cells based on certain conditions, while Universal Search and Banded search are not relevant to this scenario.

Case EX 9-2 Matt Runs a Local Cat Shelter