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…

The correct answer is A. Autofilter. 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 Answer options B and D are incorrect. There are no such options defined in…

Create advanced charts and tables

Question

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?

Options

AAutofilter
BFind
CSort
DAll filter

How the community answered

(17 responses)

A
71% (12)
B
6% (1)
C
6% (1)
D
18% (3)

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 Answer options B and D are incorrect. There are no such options defined in Excel to filter the Answer options C is incorrect. The Sort function is used to arrange the records in ascending or descending order.

Topics

#AutoFilter#data filtering#record filtering#list filtering

Community Discussion

No community discussion yet for this question.

Full 77-427 Practice