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 15 and B2 contains 3.5, 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 15 and B2 contains 3.5, 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 requires B1 to be greater than or equal to 12 and B2 to be greater than 3.25. With B1=15 and B2=3.5, both conditions are met and therefore the formula indicates that the student is on the Dean's List.