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 = 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 < 60, "Pass", "Fail")
C) =IF(B2 = 60, "Pass", "Fail")
D) =IFERROR(IF((B2 >= 60, "Pass", "Fail"))

Quizplus · Accepted Answer

The IF function with the logical test B2>=60 checks whether the score in cell B2 is greater than or equal to 60. If it is, the function returns "Pass", otherwise it returns "Fail".

The Score of a Student Is Inserted in Cell B2