Any Solver solution requires a well-organized spreadsheet that links the variable cells with the ____, and links the known facts about the problem with the objective cell.
A) objective cell
B) range names
C) PivotTable
D) summary reports

Question

Quizplus · Accepted Answer

Solver in Excel uses the objective cell, which contains the formula that you want to optimize, to link variable cells (the cells that Solver will adjust to optimize the objective) with the goal of the optimization.

Any Solver Solution Requires a Well-Organized Spreadsheet That Links the Variable