Cali Has Just Discovered the Power of Using Text Filters

question 53

Multiple Choice

Cali has just discovered the power of using text filters to control which records display in his worksheet, and he has begun to use them often to find precisely the records he needs. The following questions are based on a camp directory table that includes First Name, Last Name, Date of Birth, Camp, and Phone Number.
-If Cali wants to find all of his campers whose last names end in "son" (such as Samson and Colson) ,what should he do?

• A)Create a text filter using the Ends With operator to display all records that have cson as the last characters in the text value.
• B)Create a text filter using the Contains operator to display all records that include son in the text value.
• C)Create a text filter using the Ends With operator to display all records that have son as the last characters in the text value.
• D)Create a text filter using the Contains operator to display all records that have son as the last characters in the text value.

---

Definitions:

Clear Reasons

Explicit and understandable motives or explanations for an action or decision.

Reinstated

Reinstated means to restore something to its former state or position, often referring to employment, status, or policies.

Negative Messages

Communications that convey unfavorable or adverse information.

Engaging Early

The strategy of initiating interaction or involvement with something or someone at an early stage to influence outcomes or build relationships.