Multiple Choice
A retailer tracks list prices and discounts in an Excel spreadsheet so owners can analyze how different sales will affect the company's bottom line. One item in Cell B4 has a list price of $172.89. Varying rates for discount 1 and discount 2 can be entered into Cells B5 and B6. Which formula should be entered into Cell B7 to calculate the net-price equivalent?
A) =B4*B5*B6
B) =B4*(1-B5) *(1-B6)
C) =1-(B5+B6)
D) =(1-B5) *(1-B6)
Correct Answer:
Verified
Correct Answer:
Verified
Q1: What is a trade discount?<br>A) A discount
Q2: Cherie's Lawn and Garden received a shipment
Q8: A statement of account lists all of
Q14: The term 3/10 EOM means that a
Q20: What is the net amount due on
Q21: John Sweeney purchased car parts and is
Q22: What format is likely to be used
Q26: Mario's Wholesale Pastas sells pasta to restaurants.
Q33: An invoice amount for $4,090.72 has the
Q40: Kermit and Chris bought a vacation package