Exam 6: What-If Analysis

What selections in the File tab do you make to load an add-in?

A valid character to separate words in a range name is ________.

If you set up a two-variable data table to calculate monthly payments on different interest rates and loan terms,what values would be a likely set of entries in the left column of your data table?

Use Paste Names to document a list of all named ranges in a workbook.

Scenario Manager is not an Excel Add-in.

Optimization models find the highest,lowest,or exact value for one particular result.

You have a worksheet with a calculation to estimate production costs based on cost of raw materials,labor,fuel and delivery costs.You would like to see what would happen if the price of fuel and raw materials spiked.Which what-if analysis tool would be best?

What are the row and column input cells in this table?

The biggest difference between Scenario Manager and Solver is Solver uses ________.

________ values replace the original value of a variable in a data table.

________ has an optional summary output of a PivotTable.

A(n)________ is a program in Excel which provides enhanced capabilities over the base installation.

The what-if analysis tool best suited to evaluating multiple scenarios within a formula is ________.

Scenario Manager can manage up to ________ scenarios.

What tool would be most effective when comparing the impact of changes in interest rate and purchase price on a new car loan?

A(n)________ is a label for a cell or range of cells which can be used in formulas.

Select ________ from the File menu to install the Solver Add-in.

Excel uses two substitution values laid out in a grid in two-variable data table.

Which is the best what-if analysis tool to determine the optimal combination of products to produce in order to maximize profit?