Matching
Match the following terms with the corresponding description.
Premises:
One-variable data table
Two-variable data table
Goal Seek
Scenario Manager
Solver
Responses:
An Excel Add-in
A structured range that contains different values for two variables to compare how these differing values affect the results for one calculated value.
A what-if analysis tool that enables you to define and manage up to 32 scenarios to compare their effects on calculated results
A tool that enables you to specify a desired result from a formula
A structured range that contains different values for one variable to compare how these values affect one or more calculated results
Correct Answer:
Premises:
Responses:
One-variable data table
Two-variable data table
Goal Seek
Scenario Manager
Solver
Premises:
One-variable data table
Two-variable data table
Goal Seek
Scenario Manager
Solver
Responses:
Related Questions
Q96: Which fields in a table are required
Q97: By creating an input mask you can
Q98: Validation rules prevent invalid data from being
Q99: Match the following Word options to the
Q100: Match the following Word options to the
Q102: When you use the _ operator,each criterion
Q103: Match the following terms with the corresponding
Q104: Match the following word options to their
Q105: Match the meanings with the following terms.
Q106: _ functions refers to using one formula