Case-Based Critical Thinking Questions
Case 10-2
As you begin to work with Solver,you have questions so you turn to your roommate,Barat,who you know is an expert in its usage.
-Barat explains that if you have a cell that is the sales price of a given product,the value of which will change to produce the desired Solver result in the target cell,this cell is what kind of cell?
A) goal cell
B) constraint
C) changing cell
D) absolute cell

Question

Quizplus · Accepted Answer

The cell that is the sales price of a given product which will change to produce the desired Solver result in the target cell is called the changing cell. The goal cell is the target cell that contains the result you want to achieve. A constraint is a rule or limitation that Solver must follow when changing the values in the changing cells. An absolute cell reference is a cell reference that will always refer to a specific cell, regardless of where it is copied or moved within a worksheet.