The score of a student is inserted in cell B2. The passing score for the subject is 60. Which of the following functions should you insert in cell C2 to check whether the student has passed or failed?
A) '=IF(B2=60, "Pass", "Fail")
B) =IF(B2
C) =IF(B2 = 60, "Pass", "Fail")
D) =IFERROR(IF((B2 = 60, "Pass", "Fail"))

Question

The score of a student is inserted in cell B2. The passing score for the subject is 60. Which of the following functions should you insert in cell C2 to check whether the student has passed or failed?
A) '=IF(B2>=60, "Pass", "Fail")
B) =IF(B2
C) =IF(B2 = 60, "Pass", "Fail")
D) =IFERROR(IF((B2 >= 60, "Pass", "Fail"))

Quizplus · Accepted Answer

Option A uses the IF function correctly to check if the score in cell B2 is greater than or equal to 60. If it is, the function returns "Pass". If it is not, the function returns "Fail". This is the appropriate function to use to determine whether a student has passed or failed a subject based on their score. Option B is incomplete, and options C and D do not use the IF function correctly.

The Score of a Student Is Inserted in Cell B2