When working with Solver, you maximize, minimize, or set the objective cell to a certain value by selecting the Max (maximum), Min (minimum), or ____ option button, respectively.
A) Value Of
B) Value
C) Cell reference
D) Number

Question

Quizplus · Accepted Answer

The "Value Of" option button allows you to set a specific value for the objective cell. However, the question is asking for the option button that is used to set the objective cell to a certain value, which is the "Value" option button. The "Cell reference" option button is used to select the cell that is the objective cell. The "Number" option button is used to enter a value directly into the objective cell, but it does not maximize, minimize, or set the objective cell to a certain value. Therefore, the best choice is option A.

When Working with Solver, You Maximize, Minimize, or Set the Objective