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.
-Julia wants to take a count of all employees who are participating in more than one committee. The data is listed in column F of a worksheet. The correct formula would be ____.

Question

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.
-Julia wants to take a count of all employees who are participating in more than one committee. The data is listed in column F of a worksheet. The correct formula would be ____.
A) =COUNTIF(F3:F13,"<1") 
B) =COUNTIF(F3:F13,">1") 
C) =COUNTIF(F3:F13,">=1") 
D) =COUNTIF(F3:F13,"=1")

Quizplus · Accepted Answer

The relational operator ">" is used to count employees who are participating in more than one committee. Therefore, the correct formula is =COUNTIF(F3:F13,">1").