A constraint in Excel Solver consists of what three pieces of information?
A) Target Cell, relationship operator, and Constraint
B) Target Cell, Changing Cells, and Constraint
C) Cell Reference, relationship operator, and Constraint
D) Cell Reference, Changing Cells, and Constraint
E) Target Cell, Changing Cells, and Cell Reference

Question

Quizplus · Accepted Answer

A constraint in Excel Solver is defined by a Cell Reference (which cell or cells are being constrained), a relationship operator (such as <=, >=, =), and a Constraint value or reference (the specific condition or value that the referenced cell(s) must meet).

A Constraint in Excel Solver Consists of What Three Pieces