Case-Based Critical Thinking Questions

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")