Question 1

Where is Scenario Manager located in Excel?

Accepted Answer

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

Question 2

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

Accepted Answer

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

Question 3

A________ is a rule that Solver has to enforce to reach the objective value.

Accepted Answer

A) binding constraint 
B) stop value 
C) nonbinding constraint 
D) step value 
A) binding constraint 
B) stop value 
C) nonbinding constraint 
D) step value

Question 4

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

Accepted Answer

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

Question 5

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

Accepted Answer

The answer of When creating a two-variable data table,the formula...

Question 6

What is the benefit of using Solver over Goal Seek and Scenario Manager?

Accepted Answer

Solver is the most robust of the What-if

Question 7

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

Accepted Answer

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

Question 8

Goal Seek can be set to minimize the objective cell.

Accepted Answer

A) True 
 B)False

Question 9

What are the benefits of using Scenario Manager?

Accepted Answer

The benefit of Scenario Manager is its a

Question 10

________ scenarios can be created within Scenario Manager.

Accepted Answer

The answer of ________ scenarios can be created within Scenario...

Question 11

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

Accepted Answer

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

Question 12

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

Accepted Answer

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

Question 13

________ specify the restrictions or limitations imposed on a spreadsheet model as Solver determines the optimum value of the objective cell.

Accepted Answer

The answer of ________ specify the restrictions or limitations imposed...

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

Match between columns
                        Premises: Scenario Manager
Scenario Summary Report
Scenario
Optimization model
Goal Seek

Accepted Answer

The Answer of Finds the highest,lowest,or exact value for one is...

Question 16

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.

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

One-variab

Question 18

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

Accepted Answer

The answer of ________ can be used to compare the...

Question 19

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

Accepted Answer

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

Question 20

Which of the following tools is an add-in?

Accepted Answer

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

Exam 13: What If Analysis

Where is Scenario Manager located in Excel?

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

A________ is a rule that Solver has to enforce to reach the objective value.

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

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

What is the benefit of using Solver over Goal Seek and Scenario Manager?

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

Goal Seek can be set to minimize the objective cell.

What are the benefits of using Scenario Manager?

________ scenarios can be created within Scenario Manager.

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

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

________ specify the restrictions or limitations imposed on a spreadsheet model as Solver determines the optimum value of the objective cell.

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

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.

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

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

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

Which of the following tools is an add-in?

Subtotals, Pivot-tables, and Pivot-charts: Hands-On-Exercise Videos

Desktop Publishing and Graphic Design: Hands On Exercise Videos

Desktop Publishing and Graphic Design: Creating a Newsletter working With Graphics and Linking Objects

Infographics: Creating Text Charts, tables, and Graphs

Subtotals Pivot-tables and Pivot-charts

Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

Infographics: Hands On Exercise Videos

Data Validation and Data Analysis: Hands On Exercise Videos

What If Analysis: Hands On Exercise Videos

Time Saving Tools: Hands On Exercise Videos

Time Saving Tools: Using Templates multiple Documents and Themes

Interactivity and Advanced Animation: Engaging the Audience

Action and Specialized Queries: Moving Beyond the Select Query

Interactivity and Advanced Animation: Hands On Exercise Videos

Action and Specialized Queries: Hands On Exercise Videos

Specialized Functions: Hands On Exercise Videos

Document Automation: Hands On Exercise Videos

Document Automation: Forms, macros, and Security

Customization: Customizing Powerpoint and the Slide Show

Specialized Functions

Advanced Forms and Reports: Moving Beyond the Basics

Customization: Hands On Exercise Videos

Advanced Forms and Reports: Hands On Exercise Videos

Statistical Functions: Hands On Exercise Videos

Word and the Internet: Hands On Exercise Videos

Word and the Internet: Web Page Creation and Enhancement and Blogs

Collaboration and Distribution: Collaborating, preparing, securing, and Sharing a Presentation

Statistical Functions

Get Connected: Exchanging Data Between Access and Other Applications

Collaboration and Distribution: Hands On Exercise Videos

Get Connected: Hands On Exercise Videos

Multiple Sheet Workbook Management: Hands On Exercise Videos

Multiple Sheet Workbook Management

Fine Tuning the Database: Analyzing and Improving Database Performance

Fine Tuning the Database: Hands On Exercise Videos

Imports, web Queries, and XML: Hands-On-Exercise Videos

Imports, web Queries, and XML

Using Macros and SQL in Access: Advanced Techniques

Using Macros and SQL in Access: Hands On Exercise Videos

Collaboration and Workbook Distribution: Hands On Exercise Videos

Collaboration and Workbook Distribution

Templates styles and Macros

Templates, styles, and Macros: Hands-On-Exercise Videos

Filters