BUSI 520 WEEK 10 QUIZ QUESTIONS AND ANSWERS
True or False: Simply rounding the solver solution is an accurate alternative to using the
integer constraint. - Answers - False
True or False: Binary numbers of 1 and 0 can be used in Solver to assign whether a
contract is awarded (or not). - Answers - True
It is more difficult to use Solver with _____ functions.
A. nonlinear
B. sequential number
C. simple
D. linear
E. None of the answers listed. - Answers - A
True or false: Solver is limited to one input and one outcome. - Answers - False
True or false: Solver's "Changing Variable Cells" can be cells with either values or
formulas. - Answers - False
The decision variables are the _____.
A. objective (or target) cells
B. constraints
C. output cells
D. None of the answers listed.
E. changing cells - Answers - E
True or False: Single-dimensional ranges used within the SUMPRODUCT function can
be oriented either horizontally or vertically, but cannot be a mix of both horizontal &
vertical ranges. - Answers - True
True or False: SUMPRODUCT ranges cannot have blank cells within the ranges. -
Answers - False
True or False: When you use Goal Seek, you are limited to entering values in a single
cell to reach a goal in another related cell. - Answers - True
True or False: $C$9:$F$9<= $C$14:$F$14 could be used as a valid solver constraint. -
Answers - True
_____ restrict the values specified for the changing variable cells.
True or False: Simply rounding the solver solution is an accurate alternative to using the
integer constraint. - Answers - False
True or False: Binary numbers of 1 and 0 can be used in Solver to assign whether a
contract is awarded (or not). - Answers - True
It is more difficult to use Solver with _____ functions.
A. nonlinear
B. sequential number
C. simple
D. linear
E. None of the answers listed. - Answers - A
True or false: Solver is limited to one input and one outcome. - Answers - False
True or false: Solver's "Changing Variable Cells" can be cells with either values or
formulas. - Answers - False
The decision variables are the _____.
A. objective (or target) cells
B. constraints
C. output cells
D. None of the answers listed.
E. changing cells - Answers - E
True or False: Single-dimensional ranges used within the SUMPRODUCT function can
be oriented either horizontally or vertically, but cannot be a mix of both horizontal &
vertical ranges. - Answers - True
True or False: SUMPRODUCT ranges cannot have blank cells within the ranges. -
Answers - False
True or False: When you use Goal Seek, you are limited to entering values in a single
cell to reach a goal in another related cell. - Answers - True
True or False: $C$9:$F$9<= $C$14:$F$14 could be used as a valid solver constraint. -
Answers - True
_____ restrict the values specified for the changing variable cells.
