Solved

If A7=21, Which of the Following =IF Statements Would Produce

Question 11

Multiple Choice

If A7=21, which of the following =IF statements would produce the result of "Much Greater"?


A) =IF(A7>14,"Greater",IF(A7>20,"Much Greater","Not Greater than 20") )
B) =IF(A7<50,"Greater",IF(A7>20,"Much Greater","Not Greater than 20") )
C) =IF(A7<14,"Greater",IF(A7>20,"Much Greater","Not Greater than 20") )
D) =IF(A7<14,"Greater",IF(A7>20,"Much Greater","Not Greater than 20")

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Q6: Which of the following would not produce

Q7: In military time, 15:00 is _ in

Q8: Which of the following would not give

Q9: The _ is the lowest value for

Q10: The range that contains the lookup table

Q12: _ references change when formulas are copy

Q13: If you will never copy and paste

Q14: Excel assigns date number 1 to January

Q15: It is called a(n)_ function when a

Q16: What does the AVERAGE function not ignore?<br>A)Text<br>B)Empty