Question

Which of the following is NOT information you can specify using the solver? *
2 points
a. Input cells
b. Constraints
c. Target cell
d. Changing cell

Answer 1

Answer:

Solver is used to find an optimal (maximum or minimum) value for a formula in one cell — called the objective cell — subject to constraints, or limits, on the values of other formula cells on a worksheet. Solver works with a group of cells, called decision variables or simply variable cells that are used in computing the formulas in the objective and constraint cells. Versions of Solver prior to Excel 2007 referred to the objective cell as the "target cell," and the decision variable cells as "changing cells" or "adjustable cells"

Answer 2

Input cells are NOT information you can specify using the solver.

What about Input cells :

• What-if analysis may be done with Solver, a Microsoft Excel add-in tool. The solver can be used to find the best value for a formula in a single cell called the objective cell that is constrained by the values of other formula cells on a worksheet.

• The solver uses a set of cells known as choice variables, or simply variable cells, to compute the formulae in the goal and constraint cells. Input cells are NOT information you can specify using the solver. The values in the choice variable cells are adjusted by Solver to fulfill the constraints on constraint cells and generate the desired outcome for the goal cell.