Question 1

Goal Seek is a what-if analysis tool.

Accepted Answer

A) True 
 B)False

Question 2

Match between columns
                        Premises: Step value
Stop value
What-if analysis
Range name
Substitution value

Accepted Answer

The Answer of Enables you to experiment with different variables is...

Question 3

To set up this two-variable data table, what is in B9?

Accepted Answer

A) Variable APR 
B) =$E$5 
C) =PMT($B$4,$B$5,$B$2) 
D) Monthly PMT 
A) Variable APR 
B) =$E$5 
C) =PMT($B$4,$B$5,$B$2) 
D) Monthly PMT

Question 4

Excel must have at least one formula in one-variable data table.

Accepted Answer

A) True 
 B)False

Question 5

A one-variable data table can be built ________.

Accepted Answer

A) vertically 
B) horizontally 
C) in column A 
D) either horizontally or vertically 
A) vertically 
B) horizontally 
C) in column A 
D) either horizontally or vertically

Question 6

It is a good idea to use a custom format to label the top left corner of a two-variable data table with a readable label.

Accepted Answer

A) True 
 B)False

Question 7

To create range names for multiple cells at once, use the ________ tool.

Accepted Answer

A) Namer 
B) Range Creator 
C) Defined Names 
D) Create from Selection 
A) Namer 
B) Range Creator 
C) Defined Names 
D) Create from Selection

Question 8

________ specify the restrictions or limitations imposed on a spreadsheet model as Solver finds an optimum value.

Accepted Answer

A) Accesses 
B) Objectives 
C) Variables 
D) Constraints 
A) Accesses 
B) Objectives 
C) Variables 
D) Constraints

Question 9

A list of active and inactive Add-ins is in the ________.

Accepted Answer

A) Options dialog box 
B) Properties Pane 
C) Add-ins dialog box 
D) View tab 
A) Options dialog box 
B) Properties Pane 
C) Add-ins dialog box 
D) View tab

Question 10

Scenario Manager can manage up to ________ scenarios.

Accepted Answer

A) 8 
B) 32 
C) 16 
D) 64 
A) 8 
B) 32 
C) 16 
D) 64

Question 11

A(n)________ is the changeable input value used in a what-if analysis.

Accepted Answer

The answer of A(n)________ is the changeable input value used...

Question 12

Use the ________ to edit, delete and create range names.

Accepted Answer

The answer of Use the ________ to edit, delete and...

Question 13

To add a column header of Payment for the calculation column in a one-variable data table, Select the cell with the calculation formula and then ________.

Accepted Answer

A) type Payment in the cell and format as desired 
B) select Custom Number format and type Payment in the type box 
C) select Custom Number format and type "Payment" in the type box 
D) open the one-variable analysis dialog and type Payment in the header field 
A) type Payment in the cell and format as desired 
B) select Custom Number format and type Payment in the type box 
C) select Custom Number format and type "Payment" in the type box 
D) open the one-variable analysis dialog and type Payment in the header field

Question 14

A valid character to separate words in a range name is ________.

Accepted Answer

The answer of A valid character to separate words in...

Question 15

________ analysis enables you to compare how changes affect a related outcome.

Accepted Answer

The answer of ________ analysis enables you to compare how...

Question 16

________ enables you to experiment with different variables or assumptions so you can compare the related outcomes.

Accepted Answer

A) PivotTables 
B) What-if analysis 
C) Goal seek 
D) Solver 
A) PivotTables 
B) What-if analysis 
C) Goal seek 
D) Solver

Question 17

Optimization models find the highest, lowest, or exact value for one particular result.

Accepted Answer

A) True 
 B)False

Question 18

A(n)________ is a rule that Solver must enforce to reach the objective value.

Accepted Answer

A) binding constraint 
B) non-binding constraint 
C) objective 
D) solving method 
A) binding constraint 
B) non-binding constraint 
C) objective 
D) solving method

Question 19

________ are the limits or restrictions placed on a Solver model.

Accepted Answer

The answer of ________ are the limits or restrictions placed...

Question 20

What are the row and column input cells in this table?

Accepted Answer

A) B5 and B4 
B) B9 
C) B6 and B2 
D) E5 and E4 
A) B5 and B4 
B) B9 
C) B6 and B2 
D) E5 and E4

Goal Seek is a what-if analysis tool.

To set up this two-variable data table, what is in B9?

Excel must have at least one formula in one-variable data table.

A one-variable data table can be built ________.

It is a good idea to use a custom format to label the top left corner of a two-variable data table with a readable label.

To create range names for multiple cells at once, use the ________ tool.

________ specify the restrictions or limitations imposed on a spreadsheet model as Solver finds an optimum value.

A list of active and inactive Add-ins is in the ________.

Scenario Manager can manage up to ________ scenarios.

A(n)________ is the changeable input value used in a what-if analysis.

Use the ________ to edit, delete and create range names.

To add a column header of Payment for the calculation column in a one-variable data table, Select the cell with the calculation formula and then ________.

A valid character to separate words in a range name is ________.

________ analysis enables you to compare how changes affect a related outcome.

________ enables you to experiment with different variables or assumptions so you can compare the related outcomes.

Optimization models find the highest, lowest, or exact value for one particular result.

A(n)________ is a rule that Solver must enforce to reach the objective value.

________ are the limits or restrictions placed on a Solver model.

What are the row and column input cells in this table?

Introduction to Excel

Formulas and Functions

Charts

Datasets and Tables

Subtotals, Pivottables, and Pivotcharts

Specialized Functions

Statistical Functions

Multiple-Sheet Workbook Management

Imports, Xml, and Power Add-Ins

Collaboration and Workbook Distribution

Templates, Styles, and Macros

Appendix: Exploring Microsoft Office Excel 2016 Comprehensive Poatsygrauer

Filters

Exam 6: What-If Analysis

Goal Seek is a what-if analysis tool.

To set up this two-variable data table, what is in B9?

Excel must have at least one formula in one-variable data table.

A one-variable data table can be built ________.

It is a good idea to use a custom format to label the top left corner of a two-variable data table with a readable label.

To create range names for multiple cells at once, use the ________ tool.

________ specify the restrictions or limitations imposed on a spreadsheet model as Solver finds an optimum value.

A list of active and inactive Add-ins is in the ________.

Scenario Manager can manage up to ________ scenarios.

A(n)________ is the changeable input value used in a what-if analysis.

Use the ________ to edit, delete and create range names.

To add a column header of Payment for the calculation column in a one-variable data table, Select the cell with the calculation formula and then ________.

A valid character to separate words in a range name is ________.

________ analysis enables you to compare how changes affect a related outcome.

________ enables you to experiment with different variables or assumptions so you can compare the related outcomes.

Optimization models find the highest, lowest, or exact value for one particular result.

A(n)________ is a rule that Solver must enforce to reach the objective value.

________ are the limits or restrictions placed on a Solver model.

What are the row and column input cells in this table?

Introduction to Excel

Formulas and Functions

Charts

Datasets and Tables

Subtotals, Pivottables, and Pivotcharts

Specialized Functions

Statistical Functions

Multiple-Sheet Workbook Management

Imports, Xml, and Power Add-Ins

Collaboration and Workbook Distribution

Templates, Styles, and Macros

Appendix: Exploring Microsoft Office Excel 2016 Comprehensive Poatsygrauer

Filters