Question 1

The three items that you must specify when using Solver are ____.

Accepted Answer

A)  target cell,input value,and results 
B)  target cell,variable cell,and parameters 
C)  variable cell,parameters,and constraints 
D)  variable cell,objective cell,and constraints 
A)  target cell,input value,and results 
B)  target cell,variable cell,and parameters 
C)  variable cell,parameters,and constraints 
D)  variable cell,objective cell,and constraints

Question 2

If Solver is taking too long to find a solution,you can halt the program at any time by pressing the ____ key.

Accepted Answer

A)  Alt 
B)  Enter 
C)  Esc 
D)  Ctrl 
A)  Alt 
B)  Enter 
C)  Esc 
D)  Ctrl

Question 3

To set up a(n)____________________ table,you first insert references to the input and result cells.

Accepted Answer

The answer of To set up a(n)____________________ table,you first insert...

Question 4

Scenario summary tables and scenario ____ can be used to obtain a quick snapshot of several possible outcomes.

Accepted Answer

A)  PivotTables 
B)  Linear Tables 
C)  Non Linear Tables 
D)  Data Tables 
A)  PivotTables 
B)  Linear Tables 
C)  Non Linear Tables 
D)  Data Tables

Question 5

To calculate multiple cells values,select the range and type the array formula,then press the ____ keys to enter the formula.

Accepted Answer

A)  Alt+Enter 
B)  Ctrl+Shift+Enter 
C)  Alt+Shift+Enter 
D)  Ctrl+Enter 
A)  Alt+Enter 
B)  Ctrl+Shift+Enter 
C)  Alt+Shift+Enter 
D)  Ctrl+Enter

Question 6

As in traditional what-if analysis,Goal Seek starts with the end result and determines what value you should use to reach a desired answer.

Accepted Answer

A) True 
 B)False

Question 7

After trying out solutions for a short time,Solver displays the ____ dialog box,which displays the message that indicates Solver has found a solution that satisfies the constraints.

Accepted Answer

A)  Solver Answer 
B)  Solver Solution 
C)  Solver Results 
D)  Solution 
A)  Solver Answer 
B)  Solver Solution 
C)  Solver Results 
D)  Solution

Question 8

-If you want to concentrate on only a few key cells,the scenario summary report has ____________________ tools so you can hide and expand different parts of the report.

Accepted Answer

The answer of  
-If you want to concentrate on...

Question 9

-The item marked 3 in the accompanying figure indicates the ____ expenses.

Accepted Answer

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

Question 10

Cells that display the value ____ indicate that all of the values in the worksheet satisfy the Solver constraints.

Accepted Answer

A)  TRUE 
B)  YES 
C)  1 
D)  0 
A)  TRUE 
B)  YES 
C)  1 
D)  0

Question 11

{=SUM(B1:B10*C1:C10)} is an example of a(n)____.

Accepted Answer

A)  array formula 
B)  TABLE function 
C)  scenario 
D)  input value 
A)  array formula 
B)  TABLE function 
C)  scenario 
D)  input value

Question 12

-In the dialog box in the accompanying figure,you specify the ____ in the To value box.

Accepted Answer

A)  changing 
B)  variable 
C)  input 
D)  goal 
A)  changing 
B)  variable 
C)  input 
D)  goal

Question 13

A scenario ____ lists the value for changing cells and results cells under each scenario.

Accepted Answer

A)  revenue report 
B)  summary report 
C)  index sample 
D)  profit report 
A)  revenue report 
B)  summary report 
C)  index sample 
D)  profit report

Question 14

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-The difference between the value in a cell and the value at the limit of the constraint

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 15

To open the Solver Parameters dialog box,click the Solver button in the ____ group on the Data tab.

Accepted Answer

A)  Connections 
B)  Analysis 
C)  Data Tools 
D)  External Data 
A)  Connections 
B)  Analysis 
C)  Data Tools 
D)  External Data

Question 16

You should always clearly label the row or column containing the input and result values.

Accepted Answer

A) True 
 B)False

Question 17

Elasticity measures how changing prices can affect the ____ a good or service.

Accepted Answer

A)  production of 
B)  demand for 
C)  longevity of 
D)  value of 
A)  production of 
B)  demand for 
C)  longevity of 
D)  value of

Question 18

-The item marked 2 in the accompanying figure is the scenario ____________________.

Accepted Answer

The answer of  
-The item marked 2 in the...

Question 19

____ are important because they ensure a realistic solution to your problem.

Accepted Answer

A)  Constraints 
B)  Parameters 
C)  Targets 
D)  Optimals 
A)  Constraints 
B)  Parameters 
C)  Targets 
D)  Optimals

Question 20

Goal Seek uses a different approach from traditional ____ analysis.

Accepted Answer

A)  trial-and-error 
B)  what-if 
C)  worksheet 
D)  hypothetical 
A)  trial-and-error 
B)  what-if 
C)  worksheet 
D)  hypothetical

The three items that you must specify when using Solver are ____.

If Solver is taking too long to find a solution,you can halt the program at any time by pressing the ____ key.

To set up a(n)____________________ table,you first insert references to the input and result cells.

Scenario summary tables and scenario ____ can be used to obtain a quick snapshot of several possible outcomes.

To calculate multiple cells values,select the range and type the array formula,then press the ____ keys to enter the formula.

As in traditional what-if analysis,Goal Seek starts with the end result and determines what value you should use to reach a desired answer.

After trying out solutions for a short time,Solver displays the ____ dialog box,which displays the message that indicates Solver has found a solution that satisfies the constraints.

-If you want to concentrate on only a few key cells,the scenario summary report has ____________________ tools so you can hide and expand different parts of the report.

-The item marked 3 in the accompanying figure indicates the ____ expenses.

Cells that display the value ____ indicate that all of the values in the worksheet satisfy the Solver constraints.

{=SUM(B1:B10*C1:C10)} is an example of a(n)____.

-In the dialog box in the accompanying figure,you specify the ____ in the To value box.

A scenario ____ lists the value for changing cells and results cells under each scenario.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -The difference between the value in a cell and the value at the limit of the constraint

To open the Solver Parameters dialog box,click the Solver button in the ____ group on the Data tab.

You should always clearly label the row or column containing the input and result values.

Elasticity measures how changing prices can affect the ____ a good or service.

-The item marked 2 in the accompanying figure is the scenario ____________________.

____ are important because they ensure a realistic solution to your problem.

Goal Seek uses a different approach from traditional ____ analysis.

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

The three items that you must specify when using Solver are ____.

If Solver is taking too long to find a solution,you can halt the program at any time by pressing the ____ key.

To set up a(n)____________________ table,you first insert references to the input and result cells.

Scenario summary tables and scenario ____ can be used to obtain a quick snapshot of several possible outcomes.

To calculate multiple cells values,select the range and type the array formula,then press the ____ keys to enter the formula.

As in traditional what-if analysis,Goal Seek starts with the end result and determines what value you should use to reach a desired answer.

After trying out solutions for a short time,Solver displays the ____ dialog box,which displays the message that indicates Solver has found a solution that satisfies the constraints.

-If you want to concentrate on only a few key cells,the scenario summary report has ____________________ tools so you can hide and expand different parts of the report.

-The item marked 3 in the accompanying figure indicates the ____ expenses.

Cells that display the value ____ indicate that all of the values in the worksheet satisfy the Solver constraints.

{=SUM(B1:B10*C1:C10)} is an example of a(n)____.

-In the dialog box in the accompanying figure,you specify the ____ in the To value box.

A scenario ____ lists the value for changing cells and results cells under each scenario.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -The difference between the value in a cell and the value at the limit of the constraint

To open the Solver Parameters dialog box,click the Solver button in the ____ group on the Data tab.

You should always clearly label the row or column containing the input and result values.

Elasticity measures how changing prices can affect the ____ a good or service.

-The item marked 2 in the accompanying figure is the scenario ____________________.

____ are important because they ensure a realistic solution to your problem.

Goal Seek uses a different approach from traditional ____ analysis.

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