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 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
Q6: When Excel automatically fills the rest of
Q19: Identify the letter of the choice that
Q27: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TBX9151/.jpg" alt=" According to
Q38: The COUNTAS function counts the number of
Q66: In most cases,when manually creating a
Q67: When you create a formula that references
Q81: If you need to modify the formula
Q93: If you edit a cell in a
Q95: In the Edit Formatting Rule dialog box
Q96: The _ function searches vertically down the