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
Q88: The _ function adds the values in
Q94: Discuss strategies for checking formulas for matching
Q95: Sometimes the built-in conditional formatting rules do
Q96: What are the guidelines to keep in
Q102: A(n)_ specifies the type of condition the
Q108: The _ function searches horizontally across a
Q113: The _ function is a logical function
Q114: The _ function searches vertically down a
Q120: The _ error value means that the
Q127: The _ function can determine if a
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents