Darryl Has a Worksheet That Displays a Product's Net Profit

question 274

Multiple Choice

Darryl has a worksheet that displays a product's net profit in cell C20. He is using Solver to determine how he can achieve the most profit by changing the values in other cells. Where should he enter a reference to cell C20 in the Solver Parameters dialog box?

• A) Set Objective box
• B) By Changing Variable Cells box
• C) Subject to the Constraints box
• D) Load/Save box

---

Definitions:

Output

The total amount of goods or services produced by a company, sector, or economy within a specific time period.

Average Total Cost

The total cost of production (fixed plus variable costs) divided by the number of units produced.

Fixed Cost

refers to expenses that do not change with the level of production or sales, such as rent, salaries, and insurance.

Cell Phones

Portable electronic devices that allow for telecommunication over a network of stations without the need for a physical connection to a telephone line.