The score of students in a subject is inserted in B2 cell and the passing score for the subject is 60.Which of these functions will you insert in C2 cell to check if the student has passed or failed?
A) =IF(B2=60,"Pass","Fail")
B) =OR(B2=60,"Pass","Fail")
C) =AND(B2=60,"Pass","Fail")
D) =NOT(OR((B2=60,"Pass","Fail"))

Question

The score of students in a subject is inserted in B2 cell and the passing score for the subject is 60.Which of these functions will you insert in C2 cell to check if the student has passed or failed?
A) =IF(B2>=60,"Pass","Fail")
B) =OR(B2>=60,"Pass","Fail")
C) =AND(B2>=60,"Pass","Fail")
D) =NOT(OR((B2>=60,"Pass","Fail"))

Quizplus · Accepted Answer

The IF function checks if B2 is greater than or equal to 60, and if it is, the result is "Pass." If it is not, the result is "Fail." This accurately checks whether the student has passed or failed based on their score in B2. Option B is incorrect because the OR function does not work with text ("Pass" and "Fail" in this case), and it also does not make sense to use OR in this situation since we are only checking one condition (B2>=60). Option C is incorrect because the AND function also does not work with text, and the syntax for the AND function is incorrect (it requires multiple Boolean conditions, not a condition and text values). Option D is incorrect because the NOT function is unnecessary and the syntax is again incorrect (it is trying to use the OR function with a condition and text values).

The Score of Students in a Subject Is Inserted in B2