Chapter 5

If none of the conditions specified in the IFS function are met, the function will return ________.

#N/A

If cell A2 contains a value that is less than 75, and "SEND" will be displayed when the logical test is FALSE, which of the following contains the correct IF function syntax?

=IF(A2<75, "DON'T SEND", "SEND")

Which of the following is the correct syntax when using the AND function within the IF function?

=IF(AND(B3<5,C1>7),"Pass","Fail")

AND, OR, and NOT are examples of Excel ________ functions.

Conjunction

The ________ function is used when the lookup_value argument checks the top row of the table_array.

HLOOKUP

The ________ function is the most commonly used logical function in Excel.

IF function

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?

IF(B7>20,"ORDER","OK")

The OR function requires ________ of the argument(s) to be TRUE.

at least one

The AND function requires ________ of the argument(s) to be TRUE.

both

The following function is an example of a(n) ________ function. =IF(SUM(H2:J7)>Total_Sales,.05,"No Commission")

nested