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:

Fixed Areas

Predefined sections in memory or on a display screen reserved for specific information or control elements.

Controller Scope Tag

An identifier used in automation and control systems to uniquely name and access a variable or tag within the scope of a controller.