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 > 50, "Good", =IF(A3 < 25, "Poor", "Good")
B) =IF(A3 < 25, "Poor") , IF(A3 < 50, "Average")
C) =IF(A3 < 25, "Poor", "Average", "Good")
D. =IF(A3 < 25, "Poor", IF(A3 < 50, "Average","Good") )
Correct Answer:

Verified
Correct Answer:
Verified
Q16: Which of these is the default layout
Q40: When you copy and paste a formula
Q51: You can apply date formats to cells
Q72: Jose inserts the formula =DATE(2021, 2, 15)
Q126: A teacher creates a table for Sports
Q258: Tomoko lists monthly sales for each region
Q412: Which of the following elements can you
Q437: Alba wants to display a picture as
Q600: Which of the following options can you
Q615: To change theme effects, click the Effects