Matching
Match each of the following tools to its best description of its function:
Premises:
Step value
Stop value
What-if analysis
Range name
Substitution value
Responses:
Enables you to experiment with different variables to observe how they affect the outcome.
Memorable name substitution for formulas
Value increments when filling a series
The value that is changed in what-if analysis.
The ending value for the series
Correct Answer:
Premises:
Responses:
Step value
Stop value
What-if analysis
Range name
Substitution value
Premises:
Step value
Stop value
What-if analysis
Range name
Substitution value
Responses:
Related Questions
Q17: Goal Seek changes multiple variables to reach
Q18: Associate the following concepts with its corresponding
Q19: If Solver is installed on your computer,
Q20: Which of these would be a good
Q21: Goal Seek is a what-if analysis tool.
Q23: To set up this two-variable data table,
Q24: Excel must have at least one formula
Q25: A one-variable data table can be built
Q26: It is a good idea to use
Q27: To create range names for multiple cells