Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft Exam 77-888 Topic 1 Question 2 Discussion

Actual exam question for Microsoft's exam
Question #: 2
Topic #: 1
[All Questions]

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?

Show Suggested Answer Hide Answer
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.


Contribute your Thoughts:

Currently there are no comments in this discussion, be the first to comment!


Save Cancel