Question

What is the maximum number of cells a user can select for the Set Objective variable in the Solver Parameters dialog box?

A. A user can select only a single cell for the Set Objective variable.


B. A user can select up to three cells for the Set Objective variable.


C. A user can select any number of cells for the Set Objective variable.


D. A user can select as many active cells as a worksheet contains for the Set Objective variable.

Answer 1

*clears throat* ........... its a ........ thank you for your time ....... *standing ovation*

Answer 2

A. A user can select only a single cell for the Set Objective variable

Explanation: The set objective variable cell in solver is one of the three main parameters which should be defined when trying to work with the excel solver program. The objective cell usually represents a single cell which contains the formula that represents the goal or objective of the problem at hand by tweaking the values in the variable cells based on certain defined constraints stated by the user. The goal may be to minimize, maximize or achieve a specified target value.