The Spreadsheet Cell That Contains the Total Cost of the Transportation

question 25

Multiple Choice

The spreadsheet cell that contains the total cost of the transportation plan is known as the __________ in Excel's Solver dialog box.

• A)Changing Cell
• B)Target Cell
• C)Constraint Cell
• D)Total Cost Cell

---

Definitions:

Economic value

The monetary worth of a good or service as determined by the market.

Deferred annuity

An annuity contract that delays payments of income, installments, or a lump sum until the investor elects to receive them.

Ordinary annuity

Regular payments of the same amount made at set intervals, during which interest is calculated and added at the end of each period.

Conditional sale contract

An agreement where the sale is conditional upon certain terms, often used in property and vehicle sales where possession is granted but legal ownership is retained by the seller until full payment is received.