Multiple Choice
Jason wants to display the text "Poor" if the value in cell A3 is less than 25.If the value in cell A3 is less than 50, Jason wants to display "Average"; otherwise, he wants to display "Good".Which of the following formulas should he use?
A) '=IF(A3 < 25, "Poor", IF(A3 < 50, "Average","Good") )
B) =IF(A3 < 25, "Poor", "Average", "Good")
C) =IF(A3 < 25, "Poor") , IF(A3 < 50, "Average")
D) IF(A3 > 50, "Good", =IF(A3 < 25, "Poor", "Good")
Correct Answer:

Verified
Correct Answer:
Verified
Q43: Which of the following lets you edit
Q49: When should you use relative cell references?<br>A)
Q56: When you underline cell content,you are using
Q87: A _ is a calculated named field
Q90: When would you explode a slice in
Q91: To outline data, select the rows or
Q93: Sven wants to use a more vivid
Q95: Marguerite changes her Excel security settings to
Q96: If the answer to a what-if question
Q97: A(n) _ is a section of columns