Case-Based Critical Thinking Questions

question 47

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.

---

Definitions:

P-value

A statistical measure that indicates the probability of observing the test results, or something more extreme, if the null hypothesis is true.

Null Hypothesis

A hypothesis that suggests there is no statistical significance between the specified sets of observations, usually representing a statement of no effect or no difference.

Alternative Hypothesis

The hypothesis in a statistical test that proposes a difference or effect, opposing the null hypothesis, and is considered true if the null hypothesis is rejected.

Alternative Hypothesis

A statement that proposes a new theory or relationship, typically suggesting that there is a statistically significant effect or association between variables.