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 44 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
Excellent

DylanD1323

  • Member
  • Posts: 314
Reply 3 on: Yesterday
Gracias!

« previous next »
 

Did you know?

The ratio of hydrogen atoms to oxygen in water (H2O) is 2:1.

Did you know?

Giardia is one of the most common intestinal parasites worldwide, and infects up to 20% of the world population, mostly in poorer countries with inadequate sanitation. Infections are most common in children, though chronic Giardia is more common in adults.

Did you know?

Human stomach acid is strong enough to dissolve small pieces of metal such as razor blades or staples.

Did you know?

Each year in the United States, there are approximately six million pregnancies. This means that at any one time, about 4% of women in the United States are pregnant.

Did you know?

About 3.2 billion people, nearly half the world population, are at risk for malaria. In 2015, there are about 214 million malaria cases and an estimated 438,000 malaria deaths.

Abnormalities of the Spine, Scoliosis, Kyphosis, Lordosis, List Abnormalities of the Spine, Scoliosis, Kyphosis, Lordosis, List
The recent mass upheavals in Tunisia, Egypt, Libya, Yemen, and Syria gave political scientists a cha The recent mass upheavals in Tunisia, Egypt, Libya, Yemen, and Syria gave political scientists a cha
Sample budget spreadsheet form for first year of business. Sample budget spreadsheet form for first year of business.
Oil supply and prices affect the economies of nations Oil supply and prices affect the economies of nations
Natural Resource Prices, 1850–2010 Natural Resource Prices, 1850–2010
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 ...
Video: Chemical Equilibrium between N2O4 (colorless gas) and NO2 (brown gas)

For a complete list of videos, visit our video library