A Retailer Tracks List Prices and Discounts in an Excel

question 25

Multiple Choice

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

---

Definitions:

Business Broker

A professional who assists in the buying and selling of businesses, acting as an intermediary between buyers and sellers.

Small Business Administration (SBA)

The Small Business Administration (SBA) is a U.S. government agency that provides support to entrepreneurs and small businesses, including financial assistance, counseling, and training programs.

Real Estate Broker

A licensed individual or firm that acts as an intermediary between buyers and sellers of real estate properties, often earning a commission for facilitating transactions.

FTC

The Federal Trade Commission, a U.S. government agency focused on consumer protection and maintaining competition.