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.
-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")
Correct Answer:
Verified
Correct Answer:
Verified
Q40: The _ wildcard specifies that a single
Q41: The _ wildcard specifies that any number
Q42: The _ is a measure of how
Q43: Microsoft Excel allows you to use _,
Q44: Case-Based Critical Thinking Questions<br>Case 2-1<br> <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB3934/.jpg"
Q46: To split an Excel window vertically, click
Q47: Case-Based Critical Thinking Questions<br>Case 2-2<br> <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB3934/.jpg"
Q48: If you wrote the formula =ROUNDDOWN (25.83%,2),
Q49: Microsoft Excel provides a variety of predefined
Q50: The values TRUE and FALSE are referred