The following formula is used to determine Dean's List status: =AND(B1=12,B23.25).Use the information provided to evaluate the formula.
-Assuming that B1 contains 12 and B2 contains 3.25,then _____.
A)the formula indicates that the student is on the Dean's List
B)the formula indicates that the student is NOT on the Dean's List
C)the formula returns a value of 0
D)the formula returns an error message

Question

The following formula is used to determine Dean's List status: =AND(B1>=12,B2>3.25).Use the information provided to evaluate the formula.
-Assuming that B1 contains 12 and B2 contains 3.25,then _____.
A)the formula indicates that the student is on the Dean's List
B)the formula indicates that the student is NOT on the Dean's List
C)the formula returns a value of 0
D)the formula returns an error message

Quizplus · Accepted Answer

The formula =AND(B1>=12,B2>3.25) requires both conditions to be true. Since B2 is not greater than 3.25 (it is equal), the formula returns FALSE, indicating the student is NOT on the Dean's List.

The Following Formula Is Used to Determine Dean's List Status