When the logical test in a formula that uses the IF function evaluates to TRUE, the value in the second argument is returned.

True

False

What does =(5-1)3 evaluate to?

The value in C8 is 8. What would the following formula return as a value? =IF(C8 > 7, "Here", "There")

Nothing

"There"

"Here"

No answer text provided.

If A7 contains the value FALSE and B7 contains the value FALSE, what would the following expression return? AND(A7, B7)

1

FALSE

TRUE

-1

If B17 contains the value FALSE and E24 contains the value TRUE, what would the following expression return? OR(B17, E24)

1

1

FALSE

TRUE

C1 contains the value 33. The Excel function MOD() returns the remainder of a division. What would the following formula return? =IF(MOD(C1,2),"Odd number","Even number")

"Even number"

"Odd number"

#NA

No answer text provided.

C1 has the value 0.05. SalesTaxRate is a named range for C1.

C2 has the value 0. NoTax is a named range for C2.

A1 has the value 10.

B1 has the value TRUE.

What would the following formula return as a value?

=A1 * IF(B1=TRUE, SalesTaxRate, NoTax)

0

1

#NA

0.5

Given the following data in A1:C8, which function should be used to get the average quantity supplied by one of the suppliers? B A 1 Product 2 Apples 3 Bananas 4. Apples 5 Bananas 6 Bananas 7 Oranges 8 Bananas Supplier John Mike Mike John Fred Erika Erika Quantity 200 350 240 320 230 120 400 Given the following data in A1:C8, what should be the third argument in the SUMIF formula that calculates the total quantity of bananas supplied. A 1 Product 2 Apples 3 Bananas 4 Apples 5 Bananas 6 Bananas 7 Oranges 8 Bananas B. Supplier John Mike Mike John Fred Erika Erika Quantity 200 350 240 320 230 120 400 Given the following data in A1:D9, what should be the first argument in the averagelFs formula to get the average quantity of apples supplied by one of the suppliers? A B C D 1 Date 2 January 3 January 4 February 5 February 6 February 7 February 8 March 9 March Product Apples Bananas Apples Bananas Bananas Oranges Bananas Apples Supplier John Mike Mike John Fred Erika Erika Erika Quantity 200 350 240 320 230 120 400 300 D2:09 B2 B2:39 "apples