Solved

Case-Based Critical Thinking Questions

Question 80

Multiple Choice

Case-Based Critical Thinking Questions
Case 2-1
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. -If the Human Resources director wanted a list of people who do have 100% attendance, the correct formula would be ____. A) =COUNTIF(E3:E13, <>1 ) B) =COUNTIF(E3:E13, =1 ) C) =COUNTIF(E3:E13, >=1 ) D) =COUNTIF(E3:E13, <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.
-If the Human Resources director wanted a list of people who do have 100% attendance, the correct formula would be ____.


A) =COUNTIF(E3:E13,"<>1")
B) =COUNTIF(E3:E13,"=1")
C) =COUNTIF(E3:E13,">=1")
D) =COUNTIF(E3:E13,"<1")

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Q75: To obtain the value for the lowest

Q76: The statistical function MODE returns the most

Q77: With the COUNTIF function, the first time

Q78: A format code can include up to

Q79: The Format Cells dialog box, which can

Q81: The syntax of the AVERAGEIF function _

Q82: When working with the RAND and RANDBETWEEN

Q83: If you wrote the formula =ODD(1.23), the

Q84: The _ symbol indicates to skip the

Q85: With the LARGE function, the argument called