The score of a student inserted in the B2 cell is 65 and in the C2 cell is 75.Which of the following functions will you insert in the D2 cell so that it returns FALSE if any of the conditions are false for the values in the B2 and C2 cells?
A) =IF(B2=70,C2=80)
B) =OR(B2=70,C2=80)
C) =AND(B2=70,C2=80)
D) =NOT(OR(B2=70,C2=80))

Question

The score of a student inserted in the B2 cell is 65 and in the C2 cell is 75.Which of the following functions will you insert in the D2 cell so that it returns FALSE if any of the conditions are false for the values in the B2 and C2 cells?
A) =IF(B2>=70,C2>=80)
B) =OR(B2>=70,C2>=80)
C) =AND(B2>=70,C2>=80)
D) =NOT(OR(B2>=70,C2>=80))

Quizplus · Accepted Answer

The AND function is used to return TRUE only if all of the conditions inside the function are TRUE. In this case, we want to check if both the score in B2 is greater than or equal to 70 and the score in C2 is greater than or equal to 80. If either of these conditions is not met, then we want the function to return FALSE. Therefore, the correct function to insert in the D2 cell is =AND(B2>=70,C2>=80).

The Score of a Student Inserted in the B2 Cell