Microsoft Excel 2010 Expert — Question 17

Jack wants the rows containing the name Tom and product Jam. There are thousands of entries in the log. Plowing through all the records will be time taking.
Which option can be used to view only the relevant records?

Answer options

• A. Autofilter
• B. Find
• C. Sort
• D. All filter

Correct answer: A

Explanation

The correct answer is A, Autofilter, as it allows users to quickly filter rows based on specific criteria, such as the name Tom and product Jam. Option B, Find, would require searching individually and is not efficient for multiple criteria. Option C, Sort, merely organizes data but does not restrict what is visible. Option D, All filter, is not a recognized feature and thus is invalid.