Author Question: A retailer tracks list prices and discounts in an Excel spreadsheet so owners can analyze how ... (Read 116 times)

BrownTown3 · **on:** Jun 24, 2018

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) =B4B5B6
B) =B4(1-B5)(1-B6)
C) =1-(B5+B6)
D) =(1-B5)(1-B6)

Question 2

Kermit and Chris bought a vacation package for 3,999. There is a 4.75 sales tax added to the package. What is the total cost?
A) 4,188.95
B) 4,118.15
C) 3,817.66
D) 3,813.05