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.
This section is not available anymore. Please use the main Exam Page.77-888 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Shahid_416
1 year, 7 months ago