Case-Based Critical Thinking Questions
Case 7-1
Evaluate the following formulas and functions.
-The following formula is used to determine Dean's List status.Assuming that B1 contains 15 and B2 contains 3.5,then =AND(B1=12,B23.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 7-1
Evaluate the following formulas and functions.
-The following formula is used to determine Dean's List status.Assuming that B1 contains 15 and B2 contains 3.5,then =AND(B1>=12,B2>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 checks two conditions: that the student has at least a 3.25 GPA (B2>3.25) and that they have completed at least 12 credit hours (B1>=12). Since both of these conditions are met (B1=15, B2=3.5), the formula will return TRUE, indicating that the student is on the Dean's List.