First drop down (True, B1>B2, False, B1=B2)

Second drop down ( B1-B2, B2-B1, B1, B2)

Third drop down (B1, B2-B1, B1-B2, B2)

"Finally, which of the functiona below can give you the same result"

Drop town - SUMPRODUCT (B1:B2) , SUM(B1:B2), MIN(B1:B2), MAX(B1:B2)

You work at a store that sells umbrellas. The store has 10 umbrellas for sale on any given day. There are no other umbrellas in the store, only the 10 for sale on the shelf. After the store is closed each night, the stock of umbrellas is replenished from a warehouse. On Monday, the sun is shining. Over the course of the day, 3 customers come to the store to buy an umbrella. How many umbrellas do you sell? On Thursday it rains. Over the course of the day, 25 customers come to the store to buy an umbrella. How many umbrellas do you sell? B C Now convert the logic you just used to an Excel function. Enter an IF function in cell B4 to find the Qty Sold (Quantity Sold). You can test your skills by trying this in Excel. A 1 Supply 50 2 Demand 3 4 Qty Sold 5 40 =IF e Finally, which of the functions below can give you the same result