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