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;
7 Cards in this Set
- Front
- Back
|
A method of performing what-if analysis in which the result is known, but the value of a dependent variable is unknown.
|
Goal Seeker
|
|
|
Another method of performing what-if analysis, inwhich the result is known but more than a single variable is unknown. There may also be additional constraints on the final result.
|
Solver
|
|
|
A restriction placed on an adjustable variable in a Solver problem. For example, you can constrain Solver to
spending a minimum or maximum amount in a particular category of monthly, quarterly, or annual expenses. |
Constraint
|
|
|
Excel's term for a series of tools that you can use to solve calculations that involve one or more variables
|
what-if-analysis
|
|
|
An input value that changes depending on the outcome desired.
|
variable
|
|
|
A special name given to the variables used in a data table.
|
substitution values
|
|
|
A cell in which a list of input values from a data table is substituted.
|
Input cell
|
