Deck 9: What If Analysis: Hands On Exercise Videos

Question 1

You can have multiple scenarios in a workbook,but you can have only one scenario on each worksheet.

Answer 1

False

Question 2

To compare monthly mortgage payments,total amounts to repay a loan,and total interest based on varying the interest rate,you would use ________.

A)a multi-variable data table
B)a one-variable data table
C)Solver
D)Goal Seek

Answer 2

B

Question 3

A Solver report is displayed on the same worksheet immediately below the data.

Answer 3

False

Question 4

Goal Seek is limited to manipulating only one variable and one result.

Question 5

A scenario ________ is used to compare multiple scenarios.

A)comparison table
B)analysis table
C)relationship report
D)summary report

Question 6

________ are restrictions or limitations imposed on Solver as it determines the optimum value.

A)Bounds
B)Constraints
C)Restraints
D)Controls

Question 7

Given an interest rate,the number of years,and a planned down payment,you would use ________ to find the highest cost of a house you can afford while maintaining the monthly payment.

A)a one-variable data table
B)a two-variable data table
C)Solver
D)Goal Seek

Question 8

Solver is an add-in What-If Analysis tool.

Question 9

The ________ value replaces the original input value of the variable in a data table.

A)replacement
B)substitution
C)trial
D)sample

Question 10

When using Solver,the ________ cell contains the formula used to optimize the results.

A)objective
B)pivotal
C)changing
D)optimizing

Question 11

To optimize the monthly payments,you would designate the home cost,down payment,APR,and number of years for the loan as the ________ variable cells.

A)changing
B)objective
C)dependent
D)independent

Question 12

To compare monthly mortgage payments based on varying the interest rate and the cost of the house,you would use ________.

A)Scenario Manager
B)Goal Seek
C)a two-variable data table
D)a multi-variable data table

Question 13

In the Goal Seek dialog box,the cell reference of the desired value is entered in the ________ box.

A)To value
B)By changing cell
C)Set cell
D)Column input cell

Question 14

When entering text to be displayed in the column headings of a data table,the text must be enclosed in quotation marks.

Question 15

A plug-in is a program that has to be added to Excel to extend its functionality.

Question 16

Data tables can be constructed using one,two,or three variables.

Question 17

A series of ________ indicates that the width of a column is too narrow to display the complete number.

A)asterisks (*)
B)pound signs (#)
C)carets (^)
D)ampersands (@)

Question 18

Best-Case,Worst-Case,and Mostly Likely are descriptive names used to identify ________.

A)arguments
B)scenarios
C)parameters
D)outcomes