Case-Based Critical Thinking Questions Case 5-2 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. To find anyone whose Camp is either Day Camp , or Overnight Camp , or Nature Camp , what should he do?
A) Create a text filter using the Contains operator to display all records that have Nature anywhere in the text value.
B) Create a text filter using the Ends With operator to display all records that have Day as the last characters in the text value.
C) Create a text filter using the Begins With operator to display all records that have Overnight as the first characters in the text value.
D) Create a text filter using the Contains operator to display all records that have Camp anywhere in the text value.
Correct Answer:
Verified
Q53: Case-Based Critical Thinking Questions Case 5-2 Cali
Q55: Critical Thinking Case-Based Questions Case 5-3 As
Q56: The _ criteria filter requires the records
Q57: You select the _ option button in
Q62: Critical Thinking Case-Based Questions Case 5-3 As
Q63: Critical Thinking Case-Based Questions Case 5-3 As
Q74: With the Last Quarter criteria filter quarters
Q87: You select the _ option button in
Q98: In addition to data fields,a PivotTable uses
Q105: By default the PivotTable report uses the
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents