Question 1

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 2

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 3

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 4

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 5

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

Question 6

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 7

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

Question 8

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 9

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 10

Solver constraints can be set to restrict values to integers.

Accepted Answer

A) True 
 B)False

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

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

Accepted Answer

The answer of ________ is the tool best suited to...

Question 13

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

Accepted Answer

The Answer of A constraint that Solver enforces to reach is...

Question 14

Match between columns
                        Premises: Binding constraint
Changing variable cell
Constraint
Solver
Add-in

Accepted Answer

The Answer of A cell containing a variable whose value is...

Question 15

What is the difference between a one-variable and two-variable data table?

Accepted Answer

One- and two-variable data tables,can be

Question 16

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 17

What are the benefits of using Scenario Manager?

Accepted Answer

The benefit of Scenario Manager is its a

Question 18

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 19

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

Accepted Answer

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

Question 20

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

Exam 23: Excel : What-If Analysis

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

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

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.

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

Which of the following tools is an add-in?

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

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

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

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

Solver constraints can be set to restrict values to integers.

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

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

What is the difference between a one-variable and two-variable data table?

Where is Goal Seek located in Excel?

What are the benefits of using Scenario Manager?

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

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

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

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