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:

Avoid The Contract

To nullify or terminate a contractual agreement due to errors, fraud, or illegality.

Repudiating

A term often used in legal and financial contexts to refer to the rejection or denial of a claim, duty, or responsibility.

Capacity

In legal terms, it refers to the ability of an individual or entity to enter into a contract, including understanding its terms and being of legal age and sound mind.

Fluid Mechanics

The branch of physics concerned with the study of fluids (liquids and gases) and the forces on them, encompassing both theory and applications in engineering.