New Year Sale ! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Free Preparation Discussions
MENU
Microsoft Exam 77-888 Topic 1 Question 2 Discussion
Actual exam question for
Microsoft's
exam
Question #: 2
Topic #: 1
[All Questions]
Topic #: 1
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?
Suggested Answer:
A
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 options B and D are incorrect. There are no such options defined in Excel to filter the records.
Answer options C is incorrect. The Sort function is used to arrange the records in ascending or descending order.
Currently there are no comments in this discussion, be the first to comment!