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 151 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
Wow, this really help


Sarahjh

  • Member
  • Posts: 370
Reply 3 on: Yesterday
:D TYSM

 

Did you know?

Everyone has one nostril that is larger than the other.

Did you know?

Normal urine is sterile. It contains fluids, salts, and waste products. It is free of bacteria, viruses, and fungi.

Did you know?

Colchicine is a highly poisonous alkaloid originally extracted from a type of saffron plant that is used mainly to treat gout.

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?

A cataract is a clouding of the eyes' natural lens. As we age, some clouding of the lens may occur. The first sign of a cataract is usually blurry vision. Although glasses and other visual aids may at first help a person with cataracts, surgery may become inevitable. Cataract surgery is very successful in restoring vision, and it is the most frequently performed surgery in the United States.

For a complete list of videos, visit our video library