Question 1

Solver can be set to maximize the objective cell.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

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

Question 3

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

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

Question 4

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

Accepted Answer

Two-variab

Question 5

Match between columns
                        Premises: Non binding constraint
Objective cell
Add-in
Solver
Optimization models

Accepted Answer

The Answer of Programs that can be added to Excel is...

Question 6

Multiple objective cells can be used with Scenario Manager.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

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

Question 8

Where is Goal Seek located in Excel?

Accepted Answer

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

Question 9

Scenario Manager can create PivotTable reports.

Accepted Answer

A) True 
 B)False

Question 10

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

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

Question 11

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

Accepted Answer

scenario s

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

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

Question 14

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

Accepted Answer

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

Question 15

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

Accepted Answer

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

Question 16

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

Accepted Answer

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 
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 17

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?

Accepted Answer

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

Question 18

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?

Accepted Answer

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

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

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

Exam 13: What If Analysis

Solver can be set to maximize the objective cell.

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

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

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

Multiple objective cells can be used with Scenario Manager.

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

Where is Goal Seek located in Excel?

Scenario Manager can create PivotTable reports.

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

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

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

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

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

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

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

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?

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 substitution value replaces the original input value of a variable in a data table.

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

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