Darryl has a worksheet that displays a product's net profit in cell C20. He is using Solver to determine how he can achieve the most profit by changing the values in other cells. Where should he enter a reference to cell C20 in the Solver Parameters dialog box?
A) Set Objective box
B) By Changing Variable Cells box
C) Subject to the Constraints box
D) Load/Save box

Question

Quizplus · Accepted Answer

Cell C20 is the objective that Solver is trying to maximize or minimize, so it should be entered in the Set Objective box.

Darryl Has a Worksheet That Displays a Product's Net Profit