Exam 6: What-If Analysis

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.

The Solver Add-in is loaded by default.

If you are analyzing how much a 30 year mortgage would cost with different interest rates, the interest rate would be the ________ value in the what-if scenario.

Given this worksheet, which cell would you use in the set cell: box in Goal Seek to see how expensive of a house you can afford and keep your Mortgage Payment at $650?

What is an Excel Add-in?

What-if analysis always provides a definitive solution to a problem.

Goal Seek differs from one and two-variable data table analysis by ________.

Where would you setup the two substitution values in a two-variable data table?

A two-variable data table is the most effective tool to find the appropriate interest rate and purchase price to make a monthly payment exactly $500 in a car loan.

Scenario manager is on the ________ tab.

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

________ can define 32 different scenarios for comparison.

If you would like to determine how many bags of popcorn to sell at a profit margin of $5 to raise $100 and have no constraints, which what-if analysis tool should you choose?

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

Goal Seek is an Excel Add-in.

What is a benefit of using a range name in Excel?

________ has an optional summary output of a PivotTable.