Multiple Choice
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
Correct Answer:

Verified
Correct Answer:
Verified
Q18: The _ function enables you to display
Q24: The ORERROR function can determine if a
Q26: The table that stores the data you
Q27: _ just above a cell in the
Q53: When a lookup table is used with
Q59: When you create a calculated column you
Q71: What are the guidelines to keep in
Q91: A(n)_ specifies the type of condition the
Q105: The _ function calculates the difference between
Q121: To retrieve a particular value from a