Multiple Choice
If cell B7 contains a value that is greater than 20,and "ORDER" will be displayed when the logical test is TRUE,which of the following contains the correct IF function syntax?
A) =IF(B7<20, "ORDER", "OK")
B) =IF(B7<20, "OK", "ORDER")
C) =IF(B7>20, "ORDER", "OK")
D) =IF(B7>20, "OK", "ORDER")
Correct Answer:

Verified
Correct Answer:
Verified
Related Questions
Q71: COUNTIF and AVERAGEIF are examples of _
Q72: The foundation of a logical function is
Q73: AND,OR,and NOT are examples of Excel _
Q74: Outline-code uses the structure of functions but
Q75: At least one logical test must be
Q77: A(n)_ tree allows you to break down
Q78: All of the following statements are TRUE
Q79: The _ function can change a text
Q80: A pair of _ is needed around
Q81: The _ function allows for multiple criteria