Short Answer
Match the following terms with the corresponding description.
I.One-variable data table
II.Two-variable data table
III.Goal Seek
IV.Scenario Manager
V.Solver
A.An Excel Add-in
B.A structured range that contains different values for two variables to compare how these differing values affect the results for one calculated value.
C.A what-if analysis tool that enables you to define and manage up to 32 scenarios to compare their effects on calculated results
D.A tool that enables you to specify a desired result from a formula
E.A structured range that contains different values for one variable to compare how these values affect one or more calculated results
Correct Answer:

Verified
Correct Answer:
Verified
Q47: Match the following terms with the corresponding
Q48: _ is an Excel add-in.<br>A)Goal Seek<br>B)Scenario Manager<br>C)One-variable
Q49: When saving a Solver model which of
Q50: Solver models can be saved and restored.
Q51: Where is the check box to activate
Q53: A(n)_ is a constraint that does not
Q54: Multiple objective cells can be used with
Q55: Which what-if analysis tool is best to
Q56: Solver summary reports appear on/in a(n)_.
Q57: Which what-if analysis tool is best for