1072
QuizMultiple Choice

Modeling with Rational Functions — Unit test

Question 1072 • Crowley Credit Recovery Algebra II B

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