A Constraint in Excel Solver Consists of What Three Pieces

question 3

Multiple Choice

A constraint in Excel Solver consists of what three pieces of information?

• A) Target Cell, relationship operator, and Constraint
• B) Target Cell, Changing Cells, and Constraint
• C) Cell Reference, relationship operator, and Constraint
• D) Cell Reference, Changing Cells, and Constraint
• E) Target Cell, Changing Cells, and Cell Reference

---

Definitions:

Working Capital

The difference between a company's current assets and current liabilities, indicating the amount of liquid assets available for day-to-day operations.

Incremental Net Income

Net income resulting from a particular action or decision, calculated as the difference in total net income if the action is taken versus if it is not.

Tax Rate

The percentage at which an individual or corporation is taxed by the government on income or profits.

After-Tax Discount Rate

The discount rate used in capital budgeting that accounts for the effects of income tax.