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.
-After showing her boss the data, he asked her to run one more COUNTIF to determine who is on one or more committees. 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.
-After showing her boss the data, he asked her to run one more COUNTIF to determine who is on one or more committees. 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 correct formula is C) =COUNTIF(F3:F13,">=1") because it counts the number of cells within a range that contain numbers greater than or equal to 1, effectively counting individuals on one or more committees.