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.
Correct Answer:

Verified
Correct Answer:
Verified
Q9: The _ command automatically inserts a subtotal
Q48: In PivotTable terminology the fields that you
Q50: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB2166/.jpg" alt=" -To get to
Q51: When you create a <span
Q52: MATCHING<br>Identify the letter of the choice that
Q53: Before you complete a sort you need
Q55: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB2166/.jpg" alt=" -Records have been
Q57: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB2166/.jpg" alt=" -In the figure
Q64: _ rows and columns lets you keep
Q116: The _ criteria filter requires the records