Case-Based Critical Thinking Questions

question 25

Multiple Choice

Case-Based Critical Thinking Questions
Case 2-1

Julia is learning how to use relational operators with the COUNTIF function. Her boss handed her the chart in the above figure and asked her to solve some everyday business problems.
-On a separate project, the head of Human Resources is looking for a list of people who do not have 100% attendance. In the database, the number 1 means 100% attendance; all other numbers indicate that some work was missed (for example, .75 is 75% attendance) . The data is listed in column E of a worksheet. The correct COUNTIF formula would be ____.

• A) =COUNTIF(E3:E13,"<>1")
• B) =COUNTIF(E3:E13,"=1")
• C) =COUNTIF(E3:E13,">=1")
• D) =COUNTIF(E3:E13,"<1")

---

Definitions:

Methodical

Characterized by systematic procedures or a well-organized approach to achieve a task or objective.

Inhalant Abuse

The intentional inhaling of chemical vapors or gases to achieve a psychoactive, or mind-altering, effect.

Inhalant-Induced Anxiety Disorder

Anxiety or panic attacks triggered by the abuse of inhalable substances, leading to significant distress or impairment.

Withdrawal

The process or symptoms that occur when stopping or reducing the intake of addictive substances.