Exam 6: What-If Analysis

It is a good idea to use a custom format to label the top left corner of a two-variable data table with a readable label.

Goal Seek would be the best what-if analysis tool to use to discover the necessary interest rate to keep your car payment below $500 per month.

The number of scenarios that Scenario Manager can manage is unlimited.

Match each of the following terms to its best description: I)Scenario II)Scenario Manager III)Scenario Summary Report IV)Changing Cell V)Scenario Summary PivotTable A)Displays different scenarios with their input values and results well organized on a new worksheet B)Values that represent different possible situations C)Variable D)Tool that enables you to build different scenarios for comparison E)An optional output

To create range names for multiple cells at once,use the ________ tool.

Excel must have at least one formula in one-variable data table.

________ enables you to experiment with different variables or assumptions so you can compare the related outcomes.

Which of these characters is not an acceptable character to use in a range name?

What tool would you use to rename a named range?

Goal Seek is an Excel Add-in.

Use the ________ to edit,delete and create range names.

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.

The Solver Add-in is loaded by default.

To set up this two-variable data table,what is in B9?

What is this an example of?

Solver does not support which of the following calculations on the target cell?

Match the following range names with their appropriate description of any problem with the name: I)10YearGoal II)Ten Year Goal III)Ten_Year_Goal! IV)Goal10Year V)Ten_Year_Goal A)No problem,underscore used for readability B)No Special characters C)No problem.Numbers used appropriately D)Must start with a letter E)Spaces are not allowed

A(n)________ is a rule that Solver has to enforce to reach the objective value.

If Solver is installed on your computer,it will display on the ________ tab.