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

Verified
Correct Answer:
Verified
Q3: The _ error value appears when text
Q15: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB5278/.jpg" alt=" -According to the
Q17: To change the duplicate values background fill
Q18: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB5278/.jpg" alt=" -According to the
Q20: Even if the compare values are not
Q21: MATCHING<br>Identify the letter of the choice that
Q23: In an unqualified structured reference only the
Q73: Two common categories of formula errors in
Q96: The _ function searches vertically down the
Q118: Whenever you enter a formula into an