Question 1

Two-variable data tables are often used to explore the impact of changing two values on a single result.

Accepted Answer

A) True 
 B)False  True

Question 2

When you use Solver,you must specify the ____ that apply to your problem.

Accepted Answer

A)  adjustments 
B)  constraints 
C)  keys 
D)  indices 
A)  adjustments 
B)  constraints 
C)  keys 
D)  indices B

Question 3

Goal Seek is a program that searches for the optimal solution of a problem involving several variables._________________________

Accepted Answer

A) True 
 B)False  False

Question 4

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Means that a constraint was not a limiting factor in a Solver solution

Accepted Answer

A) Solver 
B) unit elastic 
C) constraint 
D) add-in 
E) answer report
F)not binding
G)Goal Seek
H)slack
I)limits report
J)result
K)changing
L)objective 
A) Solver 
B) unit elastic 
C) constraint 
D) add-in 
E) answer report
F)not binding
G)Goal Seek
H)slack
I)limits report
J)result
K)changing
L)objective

Question 5

-You cannot merge scenarios in situations involving multiple workbooks.

Accepted Answer

A) True 
 B)False

Question 6

The default length of time that Solver will spend on the iterative process is ____ seconds.

Accepted Answer

A)  50 
B)  100 
C)  500 
D)  1000 
A)  50 
B)  100 
C)  500 
D)  1000

Question 7

If you want to see the iterative process in action,click the ____ check box,and Excel will pause after each iteration and show the intermediate solutions that it finds.

Accepted Answer

A)  Document Iterations 
B)  Iteration Reports 
C)  Iteration Progress 
D)  Show Iteration Results 
A)  Document Iterations 
B)  Iteration Reports 
C)  Iteration Progress 
D)  Show Iteration Results

Question 8

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Adds commands and features to Excel

Accepted Answer

A) Solver 
B) unit elastic 
C) constraint 
D) add-in 
E) answer report
F)not binding
G)Goal Seek
H)slack
I)limits report
J)result
K)changing
L)objective 
A) Solver 
B) unit elastic 
C) constraint 
D) add-in 
E) answer report
F)not binding
G)Goal Seek
H)slack
I)limits report
J)result
K)changing
L)objective

Question 9

How does Goal Seek differ from traditional what-if analysis?

Accepted Answer

Goal Seek uses a different approach from

Question 10

Press the ____ key to move the insertion point from one box to the next in the accompanying figure.

Accepted Answer

A)  Tab 
B)  Ctrl 
C)  Alt 
D)  Shift 
A)  Tab 
B)  Ctrl 
C)  Alt 
D)  Shift

Question 11

____ can be used to find the curve or line that best fits a set of data or to minimize production costs for a product or service.

Accepted Answer

A)  Goal Seek 
B)  Trial and error 
C)  Scenario Manager 
D)  Solver 
A)  Goal Seek 
B)  Trial and error 
C)  Scenario Manager 
D)  Solver

Question 12

In measuring elasticity,if e=0,then changes in price have no impact on demand,which is referred to as a ____ situation and occurs when the item being sold is rare or essential.

Accepted Answer

A)  relatively elastic 
B)  perfectly inelastic 
C)  relatively inelastic 
D)  perfectly elastic 
A)  relatively elastic 
B)  perfectly inelastic 
C)  relatively inelastic 
D)  perfectly elastic

Question 13

It is possible for Solver to be installed but not activated on your computer.

Accepted Answer

A) True 
 B)False

Question 14

A business must pay insurance and rent;these are examples of ____ expenses.

Accepted Answer

A)  fixed 
B)  variable 
C)  mixed 
D)  transitional 
A)  fixed 
B)  variable 
C)  mixed 
D)  transitional

Question 15

All of the following are array functions that can return multiple values to multiple cells EXCEPT ____.

Accepted Answer

A)  ARRAY 
B)  TREND 
C)  MINVERSE 
D)  MMULT 
A)  ARRAY 
B)  TREND 
C)  MINVERSE 
D)  MMULT

Question 16

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Cells whose values you will change within each scenario

Accepted Answer

A) Solver 
B) unit elastic 
C) constraint 
D) add-in 
E) answer report
F)not binding
G)Goal Seek
H)slack
I)limits report
J)result
K)changing
L)objective 
A) Solver 
B) unit elastic 
C) constraint 
D) add-in 
E) answer report
F)not binding
G)Goal Seek
H)slack
I)limits report
J)result
K)changing
L)objective

Question 17

Solver arrives at optimal solutions through a(n)____ procedure.

Accepted Answer

A)  reciprocal 
B)  iterative 
C)  secondary 
D)  convergent 
A)  reciprocal 
B)  iterative 
C)  secondary 
D)  convergent

Question 18

In Solver,a(n)____________________ cell is a cell that you want to maximize,minimize,or change to a specific value.

Accepted Answer

The answer of In Solver,a(n)____________________ cell is a cell that...

Question 19

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Cells that contain the calculated values you want to examine

Accepted Answer

A) Solver 
B) unit elastic 
C) constraint 
D) add-in 
E) answer report
F)not binding
G)Goal Seek
H)slack
I)limits report
J)result
K)changing
L)objective 
A) Solver 
B) unit elastic 
C) constraint 
D) add-in 
E) answer report
F)not binding
G)Goal Seek
H)slack
I)limits report
J)result
K)changing
L)objective

Question 20

A(n)____ procedure means that Solver starts with an initial solution and uses that as a basis to calculate a series of solutions.

Accepted Answer

A)  reciprocal 
B)  iterative 
C)  secondary 
D)  convergent 
A)  reciprocal 
B)  iterative 
C)  secondary 
D)  convergent

Two-variable data tables are often used to explore the impact of changing two values on a single result.

When you use Solver,you must specify the ____ that apply to your problem.

Goal Seek is a program that searches for the optimal solution of a problem involving several variables._________________________

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Means that a constraint was not a limiting factor in a Solver solution

-You cannot merge scenarios in situations involving multiple workbooks.

The default length of time that Solver will spend on the iterative process is ____ seconds.

If you want to see the iterative process in action,click the ____ check box,and Excel will pause after each iteration and show the intermediate solutions that it finds.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Adds commands and features to Excel

How does Goal Seek differ from traditional what-if analysis?

Press the ____ key to move the insertion point from one box to the next in the accompanying figure.

____ can be used to find the curve or line that best fits a set of data or to minimize production costs for a product or service.

In measuring elasticity,if e=0,then changes in price have no impact on demand,which is referred to as a ____ situation and occurs when the item being sold is rare or essential.

It is possible for Solver to be installed but not activated on your computer.

A business must pay insurance and rent;these are examples of ____ expenses.

All of the following are array functions that can return multiple values to multiple cells EXCEPT ____.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Cells whose values you will change within each scenario

Solver arrives at optimal solutions through a(n)____ procedure.

In Solver,a(n)____________________ cell is a cell that you want to maximize,minimize,or change to a specific value.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Cells that contain the calculated values you want to examine

A(n)____ procedure means that Solver starts with an initial solution and uses that as a basis to calculate a series of solutions.

Getting Started With Excel

Formatting a Workbook

Working With Formulas and Functions

Enhancing a Workbook With Charts and Graphs

Working With Excel Tables, Pivot-tables, and Pivot-charts

Managing Multiple Worksheets and Workbooks

Using Advanced Functions and Conditional Formatting

Developing an Excel Application

Working With Financial Tools and Functions

Connecting to External Data

Expanding Excel With Visual Basic for Applications

Managing Your Files

Getting Started With Microsoft Office 2010

Filters

Exam 10: Performing What-If Analyses

Two-variable data tables are often used to explore the impact of changing two values on a single result.

When you use Solver,you must specify the ____ that apply to your problem.

Goal Seek is a program that searches for the optimal solution of a problem involving several variables._________________________

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Means that a constraint was not a limiting factor in a Solver solution

-You cannot merge scenarios in situations involving multiple workbooks.

The default length of time that Solver will spend on the iterative process is ____ seconds.

If you want to see the iterative process in action,click the ____ check box,and Excel will pause after each iteration and show the intermediate solutions that it finds.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Adds commands and features to Excel

How does Goal Seek differ from traditional what-if analysis?

Press the ____ key to move the insertion point from one box to the next in the accompanying figure.

____ can be used to find the curve or line that best fits a set of data or to minimize production costs for a product or service.

In measuring elasticity,if e=0,then changes in price have no impact on demand,which is referred to as a ____ situation and occurs when the item being sold is rare or essential.

It is possible for Solver to be installed but not activated on your computer.

A business must pay insurance and rent;these are examples of ____ expenses.

All of the following are array functions that can return multiple values to multiple cells EXCEPT ____.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Cells whose values you will change within each scenario

Solver arrives at optimal solutions through a(n)____ procedure.

In Solver,a(n)____________________ cell is a cell that you want to maximize,minimize,or change to a specific value.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Cells that contain the calculated values you want to examine

A(n)____ procedure means that Solver starts with an initial solution and uses that as a basis to calculate a series of solutions.

Getting Started With Excel

Formatting a Workbook

Working With Formulas and Functions

Enhancing a Workbook With Charts and Graphs

Working With Excel Tables, Pivot-tables, and Pivot-charts

Managing Multiple Worksheets and Workbooks

Using Advanced Functions and Conditional Formatting

Developing an Excel Application

Working With Financial Tools and Functions

Connecting to External Data

Expanding Excel With Visual Basic for Applications

Managing Your Files

Getting Started With Microsoft Office 2010

Filters