The score of a student in two subjects are inserted in B2 and C2 cell and the passing score for each subject is 60.which of these functions will you insert in D2 cell to get FALSE as the result if the student has passed and TRUE as the result if the student has failed?
A) =IF(B2=60,C2=60)
B) =NOT(OR(B2=60,C2=60))
C) =OR(B2=60,"Pass","Fail")
D) =AND(B2=60,"Pass","Fail")

Question

The score of a student in two subjects are inserted in B2 and C2 cell and the passing score for each subject is 60.which of these functions will you insert in D2 cell to get FALSE as the result if the student has passed and TRUE as the result if the student has failed?
A) =IF(B2>=60,C2>=60)
B) =NOT(OR(B2>=60,C2>=60))
C) =OR(B2>=60,"Pass","Fail")
D) =AND(B2>=60,"Pass","Fail")

Quizplus · Accepted Answer

The NOT function will reverse the result of the OR function which checks if either B2 or C2 is greater than or equal to 60. This will give FALSE if the student has passed (since at least one subject is above passing score) and TRUE if the student has failed (since both subjects are below passing score).

The Score of a Student in Two Subjects Are Inserted