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?
A.
Autofilter
B.
Sort
C.
Find
D.
All filter
Explanation:
Autofilter is used to filter the record as per the condition by hiding the rest. Defining different filters,
you can compare data in multiple ways, so you can glean vital information without wasting vital time.
Answer C and D are incorrect. There are no such options defined in Excel to filter the records.
Answer B is incorrect. The Sort function is used to arrange the records in ascending or descending
order.