Cali Has Just Discovered the Power of Using Text Filters

question 62

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 named Cathy,Carla,and Carey,what should she do?

• A)Create a text filter using the Begins With operator to display all records that have Ca at the beginning of the text value.
• B)Create a text filter using the Contains operator to display all records that have Ca at the beginning of the text value.
• C)Create a text filter using the Begins With operator to display all records that have Car at the beginning of the text value.
• D)Create a text filter using the Contains operator to display all records that include Ca in the text value.