Question 1

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

Accepted Answer

The Answer of Specifies the cell that contains a formula is...

Question 2

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 3

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?

Accepted Answer

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

Question 4

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 5

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 6

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 7

Goal Seek appears in which tab group within Excel?

Accepted Answer

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

Question 8

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 9

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 10

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

Accepted Answer

A) True 
 B)False

Question 11

Multiple objective cells can be used with Scenario Manager.

Accepted Answer

A) True 
 B)False

Question 12

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 13

Substitution values can be manually entered.

Accepted Answer

A) True 
 B)False

Question 14

Multiple objective cells can be used with Goal Seek.

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

The Answer of Detailed sets of values that represent different is...

Question 16

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

Accepted Answer

One-variab

Question 17

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

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

Accepted Answer

A) True 
 B)False

Question 20

Solver can be set to maximize the objective cell.

Accepted Answer

A) True 
 B)False

Exam 23: Excel : What-If Analysis

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

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?

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

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

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

Goal Seek appears in which tab group within Excel?

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

Where is Scenario Manager located in Excel?

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

Multiple objective cells can be used with Scenario Manager.

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

Substitution values can be manually entered.

Multiple objective cells can be used with Goal Seek.

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

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

________ has the ability to restrict variable cells to integers.

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

Solver can be set to maximize the objective cell.

Office Fundamentals and File Management

Word: Document Presentation: Editing and Formatting

Word: Document Productivity: Working With Tables and Mail Merge

Word: Collaboration and Research: Communicating and Producing Professional Papers

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

Word: Time Saving Tools: Using Templates, multiple Documents, and Themes

Word: Document Automation: Forms,macros,and Security

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

Power: Introduction to Powerpoint: Creating a Basic Presentation

Power: Presentation Development: Planning and Preparing a Presentation

Power: Presentation Design: Illustrations and Infographics

Power: Powerpoint Rich Media Tools: Enhancing With Multimedia

Power: Infographics: Creating Text Charts, tables, and Graphs

Power: Interactivity and Advanced Animation: Engaging the Audience

Power: Customization: Customizing Powerpoint and the Slide Show

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

Excel: Introduction to Excel: What Is a Spreadsheet

Excel: Formulas and Functions: Performing Quantitative Analysis

Excel : Charts: Depicting Data Visually

Excel: Datasets and Tables: Managing Large Volumes of Data

Excel: Subtotals, Pivot-tables, and Pivot-charts

Excel: Specialized Functions

Excel: Statistical Functions

Excel : Multiple-Sheet Workbook Management

Excel: Imports, web Queries, and Xml

Excel : Collaboration and Workbook Distribution

Excel: Templates, styles, and Macros

Access : Introduction to Access: Finding Your Way Through an Access Database

Access: Tables and Queries in Relational Databases: Designing Databases and Extracting Data

Access: Customize,analyze,and Summarize Query Data: Creating and Using Queries to Make Decisions

Access: Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

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

Access : Action and Specialized Queries: Moving Beyond the Select Query

Access: Advanced Forms and Reports: Moving Beyond the Basics

Access: Get Connected: Exchanging Data Between Access and Other Applications

Access: Fine-Tuning the Database: Analyzing and Improving Database Performance

Filters