Question 1

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

Accepted Answer

The answer of All what-if analysis tools are located in...

Question 2

________ is the best what-if analysis tool to solve complex linear and nonlinear problems.

Accepted Answer

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

Question 3

Goal Seek is an Excel add-in.

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

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

Question 5

A(n)________ is a structured range that contains different values for one variable to compare how these values affect one or more calculated results.

Accepted Answer

one-variab

Question 6

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

Accepted Answer

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

Question 7

Match the following terms with the corresponding description.
I.Variable
II.What-if analysis
III.Substitution value
IV.Stop value
V.Step value
A.Value increments when filling a series
B.An input value that can change to other values to affect the results of a situation
C.The ending value for the series
D.A value that replaces the original input value of the variable in a data table
E.Enables you to experiment with different variables or assumptions so that you can observe and compare how these changes affect a related outcome

Accepted Answer

The answer of Match the following terms with the corresponding...

Question 8

________ is an Excel add-in.

Accepted Answer

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

Question 9

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

Accepted Answer

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

Question 10

Solver models can be saved and restored.

Accepted Answer

A) True 
 B)False

Question 11

Where is the check box to activate Solver located?

Accepted Answer

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

Question 12

Match the following terms with the corresponding description.
I.One-variable data table
II.Two-variable data table
III.Goal Seek
IV.Scenario Manager
V.Solver
A.An Excel Add-in
B.A structured range that contains different values for two variables to compare how these differing values affect the results for one calculated value.
C.A what-if analysis tool that enables you to define and manage up to 32 scenarios to compare their effects on calculated results
D.A tool that enables you to specify a desired result from a formula
E.A structured range that contains different values for one variable to compare how these values affect one or more calculated results

Accepted Answer

The answer of Match the following terms with the corresponding...

Question 13

A(n)________ is a constraint that does not restrict the target value that Solver finds.

Accepted Answer

nonbinding

Question 14

Multiple objective cells can be used with Goal Seek.

Accepted Answer

A) True 
 B)False

Question 15

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?

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 16

Solver summary reports appear on/in a(n)________.

Accepted Answer

The answer of Solver summary reports appear on/in a(n)________....

Question 17

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

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 18

________ has the ability to restrict variable cells to integers.

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 19

Match between columns
                        Premises: Optimization model
Solver
Non binding constraint
Objective cell
Binding constraint

Accepted Answer

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

Question 20

Scenario Manager can be set to maximize the objective cell.

Accepted Answer

A) True 
 B)False

Exam 13: What If Analysis

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

________ is the best what-if analysis tool to solve complex linear and nonlinear problems.

Goal Seek is an Excel add-in.

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

A(n)________ is a structured range that contains different values for one variable to compare how these values affect one or more calculated results.

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

________ is an Excel add-in.

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

Solver models can be saved and restored.

Where is the check box to activate Solver located?

A(n)________ is a constraint that does not restrict the target value that Solver finds.

Multiple objective cells can be used with Goal Seek.

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?

Solver summary reports appear on/in a(n)________.

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

________ has the ability to restrict variable cells to integers.

Scenario Manager can be set to maximize the objective cell.

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