Q3-Formulas-Test

What formula calculates the total cost if the price is in cell A1 and quantity in cell B1?

• =A1 + B1

• =A1 * B1

• =A1 / B1

• =A1 - B1

Which formula applies a 10% discount to a price in cell A1?

• =A1 * 10%

• =A1 - (A1 * 10%)

• =A1 / 10

• =A1 + (A1 * 10%)

If A1 contains a price and B1 contains tax rate, what formula calculates tax amount?

• =A1 * B1

• =A1 + B1

• =A1 - B1

• =A1 / B1

What formula calculates the average of values in A1:A5?

• =TOTAL(A1:A5)

• =AVG(A1:A5)

• =AVERAGE(A1:A5)

• =SUM(A1:A5)/COUNT(A1:A5)

What formula returns "PASS" if A1 is greater than 75, otherwise "FAIL"?

• =IF(A1 > 75, "PASS", "FAIL")

• =CHECK(A1, "PASS", "FAIL")

• =IF(A1 0

• =C1 = 0

How do you format cells in Column E to display a red background if they contain negative values?

• Apply a "Less Than" rule with value 0

• Apply a "Greater Than" rule with value 0

• Apply a "Between" rule with values -100 and 0

• Apply a "Equal To" rule with value 0

What formula extracts the first 3 letters from "McDonald's" in A1?

• =RIGHT(A1,3)

• =LEFT(A1,3)

• =MID(A1,3,3)

• =TEXT(A1,3)

Which formula combines "Order" in A1 and the transaction ID in B1 into "Order #TXN123"?

• =JOIN(A1, " #", B1)

• =MERGE(A1, " #", B1)

• =CONCATENATE(A1, " #", B1)

• =TEXT(A1, " #", B1)

What formula calculates the total revenue if the unit price is in cell A1 and quantity sold in cell B1?

• =A1 + B1

• =A1 * B1

• =A1 / B1

• =A1 - B1

Which formula applies a 15% discount to a price in cell A1?

• =A1 * 15%

• =A1 - (A1 * 15%)

• =A1 / 15

• =A1 + (A1 * 15%)