This topic contains a solution. Click here to go to the answer
« previous next »

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

BrownTown3

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


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
Reply #1 on: Jun 24, 2018
Answer to Question 1

D

Answer to Question 2

A


BrownTown3

  • Member
  • Posts: 564
Reply 2 on: Jun 24, 2018
Gracias!

aruss1303

  • Member
  • Posts: 314
Reply 3 on: Yesterday
Great answer, keep it coming :)

« previous next »
 

Did you know?

Essential fatty acids have been shown to be effective against ulcers, asthma, dental cavities, and skin disorders such as acne.

Did you know?

Never take aspirin without food because it is likely to irritate your stomach. Never give aspirin to children under age 12. Overdoses of aspirin have the potential to cause deafness.

Did you know?

People with alcoholism are at a much greater risk of malnutrition than are other people and usually exhibit low levels of most vitamins (especially folic acid). This is because alcohol often takes the place of 50% of their daily intake of calories, with little nutritional value contained in it.

Did you know?

The average person is easily confused by the terms pharmaceutics and pharmacology, thinking they are one and the same. Whereas pharmaceutics is the science of preparing and dispensing drugs (otherwise known as the science of pharmacy), pharmacology is the study of medications.

Did you know?

Earwax has antimicrobial properties that reduce the viability of bacteria and fungus in the human ear.

Bounding tracks in concrete Bounding tracks in concrete
ICD-10-CM Tabular List ICD-10-CM Tabular List
Medical Office To Do List Medical Office To Do List
Sample budget spreadsheet form for first year of business. Sample budget spreadsheet form for first year of business.
Excel hardware is introducing a new product on a new product line of capacity 800 units per ... Excel hardware is introducing a new product on a new product line of capacity 800 units per ...
PEDIGREE TO ANALYZE AND ANSWER IMAGE PLEASE PEDIGREE TO ANALYZE AND ANSWER IMAGE PLEASE
Video: Introduction to Macular Degeneration

For a complete list of videos, visit our video library