Case-Based Critical Thinking Questions
Case 8-4
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

Case-Based Critical Thinking Questions
Case 8-4
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 B1 to be at least 12 and B2 to be greater than 3.25. Since B2 is exactly 3.25, the condition B2>3.25 is not met, so the formula returns FALSE, indicating the student is NOT on the Dean's List.