Multiple Choice
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
Q18: If you are not sure of a
Q19: You <span class="ql-formula" data-value="\underline {\text
Q24: The ORERROR function can determine if a
Q27: You have been using a variety of
Q28: Lookup _ allow you to use tables
Q54: Each time you create a conditional format
Q81: The _ function is a logical function
Q91: A(n)_ specifies the type of condition the
Q105: The _ function calculates the difference between
Q133: In a fully qualified structured reference the