Question 1

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

Accepted Answer

Goal Seek

Question 2

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

Accepted Answer

A) True 
 B)False  True

Question 3

When using Scenario Manager,scenarios can be edited.

Accepted Answer

A) True 
 B)False  True

Question 4

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

Accepted Answer

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

Question 5

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

Accepted Answer

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

Question 6

Match the following terms with the corresponding description.
I.Add-in
II.Binding constraint
III.Constraint
IV.Changing variable cell
V.Solver
A.An add-in application that manipulates variables based on constraints to find the optimal solution to a problem
B.A cell containing a variable whose value changes until Solver optimizes the value in the objective cell
C.A program that can be added to Excel to provide enhanced function
D.A limitation that imposes restrictions on Solver
E.A constraint that Solver enforces to reach the target value

Accepted Answer

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

Question 7

Scenario Manager is an Excel add-in.

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

Solver can solve linear and nonlinear problems.

Accepted Answer

A) True 
 B)False

Question 10

Match between columns
                        Premises: Objective cell
Variable
Solver
Scenario Manager
Goal Seek

Accepted Answer

The Answer of A tool that identifies the necessary input is...

Question 11

Scenario summary reports update when input cells are changed.

Accepted Answer

A) True 
 B)False

Question 12

________ has the ability to generate Answer Reports.

Accepted Answer

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

Question 13

Which of the following tools can manipulate changing variable cells?

Accepted Answer

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

Question 14

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

Accepted Answer

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

Question 15

Match between columns
                        Premises: Substitution value
Two-variable data table
One-variable data table
Stop value
Step value

Accepted Answer

The Answer of Value increments when filling a series and is...

Question 16

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

Accepted Answer

The answer of The ________ replaces the original input value...

Question 17

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

Accepted Answer

The answer of ________ will vary one input value to...

Question 18

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

Accepted Answer

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

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

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

Exam 13: What If Analysis

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

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

When using Scenario Manager,scenarios can be edited.

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

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

Scenario Manager is an Excel add-in.

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

Solver can solve linear and nonlinear problems.

Scenario summary reports update when input cells are changed.

________ has the ability to generate Answer Reports.

Which of the following tools can manipulate changing variable cells?

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

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

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

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

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

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

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