Case-Based Critical Thinking Questions

question 95

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.
-If Simon wants to find all of his colleagues named Joseph,Joanne,and Josephine,what should he do?

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

---

Definitions:

Refined Sugar

Sugar that has been processed to remove impurities and achieve a high level of purity and whiteness.

Crushing Process

In mining and industry, refers to the operation of reducing a material’s size by applying force, breaking it into smaller pieces for further processing or use.

Split-Off Point

The stage in a production process where joint products can be recognized as separate products, each with its own identifiable costs.

Joint Production Process

A manufacturing process in which two or more products are produced simultaneously from the same raw materials or inputs.