This topic contains a solution. Click here to go to the answer

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

BrownTown3

  • Hero Member
  • *****
  • Posts: 564
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



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

meltdown117

  • Sr. Member
  • ****
  • Posts: 326
Answer to Question 1

D

Answer to Question 2

A




BrownTown3

  • Member
  • Posts: 564
Reply 2 on: Jun 24, 2018
:D TYSM


alvinum

  • Member
  • Posts: 317
Reply 3 on: Yesterday
Thanks for the timely response, appreciate it

 

Did you know?

When blood is exposed to air, it clots. Heparin allows the blood to come in direct contact with air without clotting.

Did you know?

The heart is located in the center of the chest, with part of it tipped slightly so that it taps against the left side of the chest.

Did you know?

Methicillin-resistant Staphylococcus aureus or MRSA was discovered in 1961 in the United Kingdom. It if often referred to as a superbug. MRSA infections cause more deaths in the United States every year than AIDS.

Methicilli ...
Did you know?

Coca-Cola originally used coca leaves and caffeine from the African kola nut. It was advertised as a therapeutic agent and "pickerupper." Eventually, its formulation was changed, and the coca leaves were removed because of the effects of regulation on cocaine-related products.

Did you know?

People about to have surgery must tell their health care providers about all supplements they take.

For a complete list of videos, visit our video library