Deck 23: Excel : What-If Analysis

Question 1

A two-variable data table allows two variables but only one result.

Answer 1

True

Question 2

Solver constraints can be set to restrict values to integers.

Answer 2

True

Question 3

Scenario Manager is an Excel add-in.

Answer 3

False

Question 4

Scenario Manager can be set to maximize the objective cell.

Question 5

Scenario summary reports update when input cells are changed.

Question 6

When creating a one-variable data table with substitution values in a vertical column,the formula reference must be on the row below and one column to the left of the first substitution value.

Question 7

Solver can be set to maximize the objective cell.

Question 8

Substitution values can be manually entered.

Question 9

A substitution value replaces the original input value of a variable in a data table.

Question 10

In order to complete a two-variable data table,a formula or reference to a formula must be entered in the top-left corner.

Question 11

Goal Seek is an Excel add-in.

Question 12

Multiple objective cells can be used with Goal Seek.

Question 13

Goal Seek can be set to minimize the objective cell.

Question 14

Deleted Solver constraints can be restored.

Question 15

Multiple objective cells can be used with Scenario Manager.

Question 16

If not specified by the user,Solver optimization models can produce negative results.

Question 17

By default,the Solver add-in is active.

Question 18

Solver models can be saved and restored.

Question 19

When creating a one-variable data table with substitution values in a horizontal row,the formula reference must be on the row below and one column to the left of the first substitution value.

Question 20

When creating a one-variable data table,one or more formulas that relate to the variable must be used.

Question 21

There is no limit to the number of scenarios that can be created with Scenario Manager.

Question 22

What is the maximum number of scenarios supported by Scenario Manager?

A)23
B)45
C)32
D)50

Question 23

Which of the following tools has the ability to manipulate constraints?

A)Goal Seek
B)Solver
C)Scenario Manager
D)Two-variable Data Table

Question 24

What what-if analysis tool would you use to compare the impact of different interest rates on a car payment?

A)Solver
B)Goal Seek
C)One-variable data table
D)Two-variable data table

Question 25

In order to complete a two-variable data table,which of the following must be included in the table?

A)Formula
B)Constraint
C)Absolute reference
D)Integer

Question 26

Which what-if analysis tool is best suited to determine the exact interest rate required for a $600 car payment repaid over five years?

A)Solver
B)Goal Seek
C)Scenario Manager
D)One-variable data table

Question 27

When using Scenario Manager,scenarios can be edited.

Question 28

Two reference formulas are required to complete a two-variable data table.

Question 29

Which of the following tools is an add-in?

A)Goal Seek
B)Scenario Manager
C)Solver
D)One-variable data table

Question 30

Which of the following tools is best suited for comparing the effects of one set of substitution values on a formula?

A)Goal Seek
B)Solver
C)Scenario Manager
D)One-variable data table

Question 31

Where is Goal Seek located in Excel?

A)Formula tab
B)Backstage
C)View tab
D)Data tab

Question 32

Scenario Manager can create PivotTable reports.

Question 33

Where is Scenario Manager located in Excel?

A)Formula tab
B)Backstage
C)Data tab
D)View tab

Question 34

Which of the following tools is best suited for comparing the effects of two variables on a formula?

A)Solver
B)Goal Seek
C)Two-variable data table
D)One-variable data table

Question 35

Which of the following tools has the ability to generate a report?

A)Goal Seek
B)Scenario Manager
C)One-variable data table
D)Two-variable data table

Question 36

Solver can solve linear and nonlinear problems.

Question 37

Which of the following is not a method supported by Solver?

A)GRG Nonlinear
B)Simplex LP
C)Evolutionary
D)Duplex

Question 38

When creating substitution values using the Series dialog box,what is the last number used in the substitution values?

A)Stop value
B)Step value
C)Integer
D)Constraint

Question 39

When creating a one-variable data table that depicts the effect of different interest rates on a car payment,the interest rate is an example of which of the following?

A)Variable
B)Constraint
C)Objective cell
D)Set cell

Question 40

What is the best tool to determine the required downpayment to reach a $700 car payment?

A)Solver
B)Goal Seek
C)Scenario Manager
D)One-variable data table

Question 41

The Solver add-in appears in which tab group when active in Excel?

A)Outline
B)Sort & Filter
C)Analysis
D)Data Tools

Question 42

Which of the following what-if analysis tools updates date in real time?

A)Solver
B)Goal Seek
C)Scenario Manager
D)One-variable data table

Question 43

Comments can be added to Scenarios in which tab or dialog box?

A)Goal Seek dialog box
B)Home tab
C)View tab
D)Scenario Manager dialog box

Question 44

How can you determine if the Solver add-in is active?

A)Solver is an option on the Home tab
B)Solver appears on the Data tab
C)Solver is available via right-click
D)Solver appears in the Goal Seek dialog box

Question 45

Which what-if analysis tool is the best tool for evaluating various scenarios based on variables within a formula?

A)Scenario Manager
B)Goal Seek
C)Solver
D)One-variable data table

Question 46

If Doug would like to determine how many hot dogs to sell at a profit margin of $10.00 to raise $250.00 without constraints,which what-if analysis tool should he use?

A)Scenario Manager
B)Goal Seek
C)Solver
D)Two-variable data table

Question 47

Which of the following tools can manipulate changing variable cells?

A)Goal Seek
B)One-variable data table
C)Two-variable data table
D)Solver

Question 48

Which what-if analysis tool is best used for creating optimization models?

A)One-variable data table
B)Two-variable data table
C)Solver
D)Goal Seek

Question 49

Which what-if analysis tool is best for manipulating one variable to determine one result?

A)Scenario Manager
B)Goal Seek
C)Solver
D)One-variable data table

Question 50

When calculating the optimal blend of down payment and interest rate to purchase an automobile,a limit of no more than a $10,000 down payment is an example of which of the following?

A)Nonbinding constraint
B)Objective cell
C)Integer
D)Set cell

Question 51

This analysis tool has the ability to handle multiple adjustable cells while minimizing,maximizing,or meeting goals.

A)Goal Seek
B)Scenario Manager
C)Solver
D)Two-variable data table

Question 52

Which dialog box enables you to specify the result cells for a scenario summary report?

A)Scenario Summary
B)Scenario Values
C)Add Scenario
D)Solver Options

Question 53

Which what-if analysis tool is best to determine the optimal amount of shoes to produce in order to maximize profit and use 100% of materials?

A)Goal Seek
B)Solver
C)Scenario Manager
D)Two-variable Data Table

Question 54

Which what-if analysis tool is best suited to calculate the impact of interest rate changes based on different economic climates?

A)Goal Seek
B)Scenario Manager
C)Solver
D)One-variable data table

Question 55

When saving a Solver model which of the following is not saved?

A)Objective value
B)Changing variable cells
C)Constraints
D)Set cell

Question 56

Goal Seek appears in which tab group within Excel?

A)Outline
B)Data Tools
C)Sort & Filter
D)Analysis

Question 57

Which what-if analysis tool is best suited to determine the input value needed to achieve a specific output?

A)Solver
B)Scenario Manager
C)Goal Seek
D)Two-variable Data Table

Question 58

Where should the formula or formula reference be located in a two-variable date table?

A)Lower right corner
B)Upper right corner
C)Top left corner
D)Lower left corner

Question 59

Which what-if analysis tool is best to determine the number of t-shirts to sell in order to earn $500 with no constraints?

A)Goal Seek
B)Solver
C)Scenario Manager
D)Two-variable data table

Question 60

Which is the best tool for determining the optimal blend of products to produce in order to maximize profit?

A)Goal Seek
B)Scenario Manager
C)Solver
D)Two-variable data table

Question 61

________ will vary one input value to reach one optimized result.

Question 62

All what-if analysis tools are located in the ________ tab.

Question 63

Which of the following calculations on the target cell is not supported by Solver?

A)Maximize
B)Range
C)Minimize
D)Exact value

Question 64

A list of active add-ins can be viewed in the ________.

A)Add-Ins Dialog box
B)Scenario Dialog box
C)Data tab
D)View tab

Question 65

User created scenarios are stored in a(n)________.

Question 66

Where is the check box to activate Solver located?

A)Data tab
B)View tab
C)Add-Ins tab
D)Add-Ins dialog box

Question 67

________ is the tool best suited to determine the down payment needed to achieve a $500.00 car payment.

Question 68

When creating a two-variable data table,the formula or reference should be placed in the ________.

Question 69

A(n)________ is used to compare the impacts of two variables on a calculated result.

Question 70

A(n)________ is an organized formatted structured report that appears in in the form of a worksheet outline.

Question 71

Which of the following what-if analysis tools has the ability to limit values to whole numbers?

A)Goal Seek
B)Scenario Manager
C)Solver
D)One-variable data table

Question 72

________ can be used to compare the effects of several scenarios on calculated results.

Question 73

Where do scenario summary reports appear?

A)A new worksheet
B)A new workbook
C)The current worksheet
D)A pop up box

Question 74

When active the Solver add-in is located on the ________ tab.

A)View
B)Formulas
C)Data
D)Insert

Question 75

Which of the following options is required to complete a Solver model?

A)Objective cell
B)Constraint
C)Set cell
D)Scenario

Question 76

________ is an Excel add-in.

A)Goal Seek
B)Scenario Manager
C)One-variable data table
D)Solver

Question 77

________ scenarios can be created within Scenario Manager.

Question 78

Scenario summary reports are placed on/in a ________.

Question 79

A(n)________ is used to compare the impacts of one variable on a calculated result.

Question 80

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