PrepAway - Latest Free Exam Questions & Answers

What will you do to accomplish the task?

You have a list of records where fields are empty in a certain column. You want to filter the list so
that you get the non-empty fields only. What will you do to accomplish the task?
Each correct answer represents a complete solution. Choose two.

PrepAway - Latest Free Exam Questions & Answers

A.
Right-click on an empty field in the column and click the Equals Blank option.

B.
Click on an empty field in the column and choose the Does Not Equal Blank option from the Selection menu.

C.
Right-click on an empty field in the column and click the Does Not Equal Blank option.

D.
Click on an empty field in the column and choose the Equals Blank option from the Selection
menu.

Explanation:
In order to accomplish the task, you will have to perform one of the following tasks:
Right-click on an empty field in the column and click the Does Not Equal Blank option.

Click on an empty field in the column and choose the Does Not Equal Blank option from the
Selection menu.

Both will display the non-empty fields only.
Answer A and D are incorrect. When you perform any of these tasks, you will get the empty fields only.


Leave a Reply