Home / Computer Fundamentals / MS Excel :: Discussion

Discussion :: MS Excel

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

  2. A.

     Input cells

    B.

     Constraints

    C.

     Target cell

    D.

     Changing cells

    View Answer

    Workspace

    Answer : Option A

    Explanation :

    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".


Be The First To Comment