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 12 and B2 contains 3.25,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 12 and B2 contains 3.25,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 AND function checks if both conditions are true. Since B2 is not greater than 3.25, the formula returns FALSE, indicating the student is NOT on the Dean's List.