What information do you need to provide to Solver so it can find the best solution to a problem? Select all the options that apply.

A) break-even cell
B) target cell
C) changing cells
D) constraints

Question

What information do you need to provide to Solver so it can find the best solution to a problem? Select all the options that apply.A)  break-even cellB)  target cellC)  changing cellsD)  constraints

Zybrea Knight · Accepted Answer

Final Answer : B, C, D, Explanation :  Solver needs to know the target cell, which is the cell that has to be maximized, minimized or set to a specific value. It also needs to know the changing cells, which will determine the values of the target cell. Finally, Solver needs to know the constraints, which are the limitations or restrictions on the changing cells. The break-even cell is not required for Solver to find the best solution.

What information do you need to provide to Solver so it can find the best solution to a problem? Select all the options that apply.

A) break-even cell
B) target cell
C) changing cells
D) constraints

Definitions

Learning Objectives

Learning Objectives

Related questions