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 ____.

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.
-If the Human Resources director wanted a list of people who do have 100% attendance, the correct formula would be ____.

Quizplus · Accepted Answer

The formula for counting people with 100% attendance would be =COUNTIF(E3:E13,"=1"). The equal sign indicates that we are looking for an exact match to the value of 1, which represents 100% attendance. Therefore, option B is the correct choice.