Which of the following is not information you can specify using the solver?

2025

Which of the following is not information you can specify using the solver?

  1. A.

    Input cells

  2. B.

    Constraints

  3. C.

    Target cell

  4. D.

    Changing cells

Attempted by 571 students.

Show answer & explanation

Correct answer: A

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"

Explore the full course: Mp Cooperative Bank 2026