Matching
Match each of the following tools to its best description of its function:
Premises:
Stop value
Step value
Substitution value
Range name
What-if analysis
Responses:
The ending value for the series
Value increments when filling a series
Enables you to experiment with different variables to observe how they affect the outcome.
Memorable name substitution for formulas
The value that is changed in what-if analysis.
Correct Answer:
Premises:
Responses:
Stop value
Step value
Substitution value
Range name
What-if analysis
Premises:
Stop value
Step value
Substitution value
Range name
What-if analysis
Responses:
Related Questions
Q30: Scenario Manager can manage up to _
Q44: A(n)_ is a program in Excel which
Q46: A(n)_ is a label for a cell
Q61: Select _ from the File menu to
Q62: Excel uses two substitution values laid out
Q74: _ values replace the original value of
Q80: _ has an optional summary output of
Q82: The what-if analysis tool best suited to
Q85: Which is the best what-if analysis tool
Q88: What tool would be most effective when