Multiple Choice
Case-Based Critical Thinking Questions
Case 5-2
Simon 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 staff directory table that includes First Name,Last Name,Office Number,Department Name,and Phone Number.
-To find anyone whose department name is either Transaction Processing,Processing Operations,or Records Processing,what should he do?
A) Create a text filter using the Contains operator to display all records that have Operations anywhere in the text value.
B) Create a text filter using the Ends With operator to display all records that have Processing as the last characters in the text value.
C) Create a text filter using the Begins With operator to display all records that have Processing as the first characters in the text value.
D) Create a text filter using the Contains operator to display all records that have Processing anywhere in the text value.
Correct Answer:
Verified
Correct Answer:
Verified
Q6: MATCHING<br>Identify the letter of the choice that
Q21: The header row must be row 1.
Q45: A table name can include all of
Q56: The Summary command automatically inserts a subtotal
Q69: What are the steps for sorting data
Q77: Table names cannot include underscores .
Q88: The _ criteria filter requires the records
Q99: In addition to displaying subtotals,the Subtotal feature
Q118: If you freeze the top row in
Q133: To delete a sort field in the