7
QuizMultiple Choice

Unit Test — Unit test

Question 7 • LHS Business Management

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

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

Explanation

The Set Objective box in Solver must refer to one cell. Solver changes the variable cells to optimize the value in that single objective cell, such as maximizing profit or minimizing cost. Therefore, the correct choice is “A user can select only a single cell for the Set Objective variable.”

AI-written and checked against the verified answer.

Previous
Next