Chloe Is Creating an Excel Spreadsheet Using a Number of Formulas

question 33

Multiple Choice

Chloe is creating an Excel spreadsheet using a number of formulas to help make some business decisions regarding her company's customers. Please refer to the figure above as you answer the questions below.
-Another way that Chloe could write the formula that would show if total purchases ever fell below $150,000 would be ____. The current value is $162,000.

• A) =B10<150
• B) =SUM(B10)<150
• C) =AND(B10)<150
• D) =B10>150

---

Definitions:

Socially Optimal Level

A state at which the allocation of resources maximizes social welfare, often where marginal social benefit equals marginal social cost.

Marginal Revenue

Marginal revenue is the additional income received from selling one more unit of a product or service.

Marginal Cost

Marginal cost is the increase or decrease in the total cost of producing one additional unit of a good or service.

Total Revenue

The total amount of money generated by a firm from the sale of its goods or services, calculated before any expenses are subtracted.