Multiple Choice
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
Correct Answer:
Verified
Correct Answer:
Verified
Q24: The ORERROR function can determine if a
Q32: The _ function calculates the number of
Q37: Case-Based Critical Thinking Questions Case 8-2 Your
Q42: To highlight duplicate values,in the Styles group
Q45: To get the effect of a calculated
Q47: The _ function can determine if a
Q62: Case-Based Critical Thinking Questions Case 8-2 Your
Q71: What are the guidelines to keep in
Q80: The <span class="ql-formula" data-value="\underline {\text
Q87: You can edit existing conditional formatting rules