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 exactly one committee. 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 exactly one committee. 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 formula that would count all employees who are participating in exactly one committee is =COUNTIF(F3:F13,"=1"). This is because the = (equal to) operator is used to match exactly one committee.