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 12 and B2 contains 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
Q10: The _ error value means that a
Q13: You can calculate the number of cells
Q47: The _ function can determine if a
Q71: What are the guidelines to keep in
Q73: Two common categories of formula errors in
Q75: To change the background fill color of
Q80: The <span class="ql-formula" data-value="\underline {\text
Q81: If you need to modify the formula
Q92: The _ function calculates the difference between
Q95: In the Edit Formatting Rule dialog box