Question 1

What-if analysis tools provide definitive solutions to problems.

Accepted Answer

A) True 
 B)False  False

Question 2

If a manager wanted to highlight a cell once its value reached the break-even point,the manager will apply the icon sets conditional formatting option.

Accepted Answer

A) True 
 B)False  False

Question 3

In Solver,the ________ cell always contains a formula.

Accepted Answer

objective

Question 4

What is the main difference between Goal Seek and variable data tables?

Accepted Answer

A) Goal Seek produces a list of result values. 
B) Goal Seek uses the original worksheet data to change an input. 
C) Goal Seek manipulates multiple variables to produce multiple results. 
D) Goal Seek shows results in a separate table. 
A) Goal Seek produces a list of result values. 
B) Goal Seek uses the original worksheet data to change an input. 
C) Goal Seek manipulates multiple variables to produce multiple results. 
D) Goal Seek shows results in a separate table.

Question 5

Through a process called ________,Goal Seek repeatedly enters new values in the variable cell to find a solution to the problem.

Accepted Answer

A) iteration 
B) repetition 
C) valuation 
D) seeking 
A) iteration 
B) repetition 
C) valuation 
D) seeking

Question 6

Solver can be used to find values that optimize an objective.

Accepted Answer

A) True 
 B)False

Question 7

In a data table,the ________ number format is used to disguise the formula references in the first row as labels.

Accepted Answer

A) Custom 
B) Scientific 
C) Text 
D) Special 
A) Custom 
B) Scientific 
C) Text 
D) Special

Question 8

Utilities such as electricity and water are examples of mixed costs.

Accepted Answer

A) True 
 B)False

Question 9

To open a saved Solver model you must first click Load/Save button on the Solver Parameters dialog box.

Accepted Answer

A) True 
 B)False

Question 10

Where do you go to begin loading the Solver add-inn?

Accepted Answer

A) Install on the Add-Ins tab 
B) Options on the File tab 
C) Add-In options on the File tab 
D) What-If Analysis on the Data tab 
A) Install on the Add-Ins tab 
B) Options on the File tab 
C) Add-In options on the File tab 
D) What-If Analysis on the Data tab

Question 11

Scenarios can be created without a formula or function on your worksheet.

Accepted Answer

A) True 
 B)False

Question 12

Which Solver report type displays various statistical characteristics about the model?

Accepted Answer

A) Solver limits report 
B) Solver statistical report 
C) Solver population report 
D) Solver sensitivity report 
A) Solver limits report 
B) Solver statistical report 
C) Solver population report 
D) Solver sensitivity report

Question 13

Solver can be used for ________.

Accepted Answer

A) complex equation solving 
B) conditional formatting 
C) consolidating data 
D) linear programming 
A) complex equation solving 
B) conditional formatting 
C) consolidating data 
D) linear programming

Question 14

In the Scenario Manager dialog box,click ________ to create a new scenario.

Accepted Answer

A) Summary 
B) Add 
C) Merge 
D) Show 
A) Summary 
B) Add 
C) Merge 
D) Show

Question 15

If a manager wanted to analyze how interest rates affect a monthly loan payment,the best data table to use will be the ________ data table.

Accepted Answer

The answer of If a manager wanted to analyze how...

Question 16

In the Goal Seek dialog box,the ________ box contains a formula.

Accepted Answer

The answer of In the Goal Seek dialog box,the ________...

Question 17

If a change in price is accompanied by a large change in quantity demanded,a product or service is considered ________.

Accepted Answer

The answer of If a change in price is accompanied...

Question 18

PivotTables allow even more manipulation of data because of the three-dimensional view they provide.

Accepted Answer

A) True 
 B)False

Question 19

What happens when you add a new scenario and generate a new scenario summary report?

Accepted Answer

A) The new report will be created on a new worksheet. 
B) The new scenario will be included into the old report. 
C) The new report will be added directly below the original report. 
D) The new report will replace the original report. 
A) The new report will be created on a new worksheet. 
B) The new scenario will be included into the old report. 
C) The new report will be added directly below the original report. 
D) The new report will replace the original report.

Question 20

A two-variable data table can be used to calculate elasticity.

Accepted Answer

A) True 
 B)False

What-if analysis tools provide definitive solutions to problems.

If a manager wanted to highlight a cell once its value reached the break-even point,the manager will apply the icon sets conditional formatting option.

In Solver,the ________ cell always contains a formula.

What is the main difference between Goal Seek and variable data tables?

Through a process called ________,Goal Seek repeatedly enters new values in the variable cell to find a solution to the problem.

Solver can be used to find values that optimize an objective.

In a data table,the ________ number format is used to disguise the formula references in the first row as labels.

Utilities such as electricity and water are examples of mixed costs.

To open a saved Solver model you must first click Load/Save button on the Solver Parameters dialog box.

Where do you go to begin loading the Solver add-inn?

Scenarios can be created without a formula or function on your worksheet.

Which Solver report type displays various statistical characteristics about the model?

Solver can be used for ________.

In the Scenario Manager dialog box,click ________ to create a new scenario.

If a manager wanted to analyze how interest rates affect a monthly loan payment,the best data table to use will be the ________ data table.

In the Goal Seek dialog box,the ________ box contains a formula.

If a change in price is accompanied by a large change in quantity demanded,a product or service is considered ________.

PivotTables allow even more manipulation of data because of the three-dimensional view they provide.

What happens when you add a new scenario and generate a new scenario summary report?

A two-variable data table can be used to calculate elasticity.

Navigate, manipulate, and Print Worksheets

Formatting, functions, and Formulas

Cell References, named Ranges, and Functions

Effective Charts

Complex Conditional and Retrieval Functions

Analyze Data Using Tables

Multiple Worksheets workbooks and Templates

Refine an Excel Application

Organize, import, export, and Cleanse Data Sets

Loan Amortization, investment Analysis, and Asset Depreciation

Business Statistics and Regression Analysis

Excels Data Model, Power-pivot, and Power View

Visual Basic for Applications

Appendix:efficient Interaction With a Touch Screen

The Common Features of Microsoft Office

Filters

Exam 10: Data Tables, scenario Manager, and Solver

What-if analysis tools provide definitive solutions to problems.

If a manager wanted to highlight a cell once its value reached the break-even point,the manager will apply the icon sets conditional formatting option.

In Solver,the ________ cell always contains a formula.

What is the main difference between Goal Seek and variable data tables?

Through a process called ________,Goal Seek repeatedly enters new values in the variable cell to find a solution to the problem.

Solver can be used to find values that optimize an objective.

In a data table,the ________ number format is used to disguise the formula references in the first row as labels.

Utilities such as electricity and water are examples of mixed costs.

To open a saved Solver model you must first click Load/Save button on the Solver Parameters dialog box.

Where do you go to begin loading the Solver add-inn?

Scenarios can be created without a formula or function on your worksheet.

Which Solver report type displays various statistical characteristics about the model?

Solver can be used for ________.

In the Scenario Manager dialog box,click ________ to create a new scenario.

If a manager wanted to analyze how interest rates affect a monthly loan payment,the best data table to use will be the ________ data table.

In the Goal Seek dialog box,the ________ box contains a formula.

If a change in price is accompanied by a large change in quantity demanded,a product or service is considered ________.

PivotTables allow even more manipulation of data because of the three-dimensional view they provide.

What happens when you add a new scenario and generate a new scenario summary report?

A two-variable data table can be used to calculate elasticity.

Navigate, manipulate, and Print Worksheets

Formatting, functions, and Formulas

Cell References, named Ranges, and Functions

Effective Charts

Complex Conditional and Retrieval Functions

Analyze Data Using Tables

Multiple Worksheets workbooks and Templates

Refine an Excel Application

Organize, import, export, and Cleanse Data Sets

Loan Amortization, investment Analysis, and Asset Depreciation

Business Statistics and Regression Analysis

Excels Data Model, Power-pivot, and Power View

Visual Basic for Applications

Appendix:efficient Interaction With a Touch Screen

The Common Features of Microsoft Office

Filters