Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
21 Cards in this Set
- Front
- Back
|
The Scenario Manager refers to input cells as the _____ cells.
|
changing
|
|
|
he SUMPRODUCT calculates the _____.
|
sum of a series of multiplication tasks
|
|
|
The output cells of the Scenario Manager are referred to as the _____ cells.
|
result
|
|
|
T/F...The input cells are the also referred to as the changing cells for creating scenarios.
|
True
|
|
|
Click the _____ button in the Scenario Manager to copy scenarios on one sheet to the active worksheet.
|
Merge
|
|
|
T/F...A PivotTable is interactive allowing you to change the detailed view of the data.
|
True
|
|
|
_____ analysis is a type of what-if analysis that attempts to examine how sensitive the results are to changes in assumptions.
|
Sensitivity
|
|
|
What allows you to evaluate multiple sets of initial conditions and assumptions (scenarios)
|
Scenario Manager
|
|
|
How can you see a comparison of all of your scenarios?
|
scenario manager
|
|
|
If there are no constraints or too few constraints, the solution is _____.
|
unbounded
|
|
|
_____ restrict the values specified for the changing cells.
|
Constraints
|
|
|
T/F...A scenario can save the result of a Solver model so that you can load it later.
|
True
|
|
|
T/F...When you use Goal Seek, you are limited to entering values in a single cell to reach a goal in another related cell.
|
True
|
|
|
If Solver attempts the maximum number of iterations without the target cell converging to an answer, the assumption is that the solution is _____.
|
unbounded
|
|
|
The decision variables are the _____.
|
changing cells
|
|
|
A(n) _____ solution results when Solver cannot determine the combination of decision variables to satisfy the constraints.
|
infeasible
|
|
|
Solver inserts values in the changing cells until the value of the _____ cell has reached the specified goal.
|
target
|
|
|
Use _____ to minimize costs or maximize profits.
|
Solver
|
|
|
T/F...Binary numbers of 0 and 1 can be used in Solver to assign whether a contract is or is not awarded.
|
True
|
|
|
How many inputs and how many outputs are the for goal seek?
|
one and one
|
|
|
What are the two ways to make is nonnegative for solver?
|
nonnegative constraints or under solver options put assume non-negative
|
