Question 1

____ are named combinations of values that are assigned to variables in a model.

Accepted Answer

A)  Constraints 
B)  Tables 
C)  Scenarios 
D)  Data validation rules 
A)  Constraints 
B)  Tables 
C)  Scenarios 
D)  Data validation rules

Question 2

You can attempt to solve a complex worksheet problem manually,also known as the trial and error method.

Accepted Answer

A) True 
 B)False

Question 3

An Answer Report shows original and final values of the target cell and changing cells plus ____.

Accepted Answer

A)  cell formatting 
B)  constraints 
C)  previous trial and error solutions 
D)  all scenarios 
A)  cell formatting 
B)  constraints 
C)  previous trial and error solutions 
D)  all scenarios

Question 4

The primary uses of the Scenario Manager include all of the following except ​

Accepted Answer

A)  ​create different scenarios with multiple sets of changing cells. 
B)  ​build summary worksheets that contain the different scenarios. 
C)  ​view the results of each scenario on your worksheet. 
D)  ​exclude cells that are input cells for your model. 
A)  ​create different scenarios with multiple sets of changing cells. 
B)  ​build summary worksheets that contain the different scenarios. 
C)  ​view the results of each scenario on your worksheet. 
D)  ​exclude cells that are input cells for your model.

Question 5

Which of the following is not a primary use of the Scenario Manager?

Accepted Answer

A)  Find a scenario-style solution to a complex problem by changing a single variable 
B)  Create different scenarios with multiple sets of changing cells 
C)  Build summary worksheets that contain the different scenarios 
D)  View the results of each scenario on a worksheet 
A)  Find a scenario-style solution to a complex problem by changing a single variable 
B)  Create different scenarios with multiple sets of changing cells 
C)  Build summary worksheets that contain the different scenarios 
D)  View the results of each scenario on a worksheet

Question 6

Each cell referenced in a formula is a dependent of the cell containing the formula.

Accepted Answer

A) True 
 B)False

Question 7

You should name ranges for all input variables before creating your first scenario.

Accepted Answer

A) True 
 B)False

Question 8

When using the Custom data validation type,you can use a formula that evaluates to either true or false.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following is the path to the Trace Precedents button?

Accepted Answer

Question 10

A constraint that is not binding is one that is not a limiting factor in the solution that Goal Seek provides.

Accepted Answer

A) True 
 B)False

Question 11

The error code #DIV / 0! indicates that there are no common cells in two ranges a formula identifies as having an intersection.

Accepted Answer

A) True 
 B)False

Question 12

Auditing the formulas in a worksheet can give you insight into how a worksheet is structured.

Accepted Answer

A) True 
 B)False

Question 13

Solver creates a Summary Solution Report on the same worksheet as the data after it finds a solution.

Accepted Answer

A) True 
 B)False

Question 14

Which of the following is NOT a type of data validation criteria you can assign to a cell?

Accepted Answer

A)  any specified value 
B)  whole numbers 
C)  dates 
D)  Bold style formatting 
A)  any specified value 
B)  whole numbers 
C)  dates 
D)  Bold style formatting

Question 15

The Simplex LP solving method uses geometric progression to solve problems.

Accepted Answer

A) True 
 B)False

Question 16

An Answer Report's ____ column indicates binding constraints.

Accepted Answer

A)  Constraints 
B)  Cell Value 
C)  Status 
D)  Formula 
A)  Constraints 
B)  Cell Value 
C)  Status 
D)  Formula

Question 17

Which of the following are methods or tools you can use to solve complex worksheet problems?

Accepted Answer

A)  trial and error 
B)  Goal Seek 
C)  Solver 
D)  data validation 
A)  trial and error 
B)  Goal Seek 
C)  Solver 
D)  data validation

Question 18

When considering an approach to a complex problem in Excel,start with the least complex method of attempting to solve the problem._________________________

Accepted Answer

A) True 
 B)False

Question 19

Which of the following are error codes?

Accepted Answer

A)  #N / A! 
B)  #VALUE! 
C)  #NULL! 
D)  #OVR / 0! 
A)  #N / A! 
B)  #VALUE! 
C)  #NULL! 
D)  #OVR / 0!

Question 20

The ____ feature is especially useful when working with very large worksheets.

Accepted Answer

A)  model 
B)  summary 
C)  outline 
D)  auditing 
A)  model 
B)  summary 
C)  outline 
D)  auditing

____ are named combinations of values that are assigned to variables in a model.

You can attempt to solve a complex worksheet problem manually,also known as the trial and error method.

An Answer Report shows original and final values of the target cell and changing cells plus ____.

The primary uses of the Scenario Manager include all of the following except

Which of the following is not a primary use of the Scenario Manager?

Each cell referenced in a formula is a dependent of the cell containing the formula.

You should name ranges for all input variables before creating your first scenario.

When using the Custom data validation type,you can use a formula that evaluates to either true or false.

Which of the following is the path to the Trace Precedents button?

A constraint that is not binding is one that is not a limiting factor in the solution that Goal Seek provides.

The error code #DIV / 0! indicates that there are no common cells in two ranges a formula identifies as having an intersection.

Auditing the formulas in a worksheet can give you insight into how a worksheet is structured.

Solver creates a Summary Solution Report on the same worksheet as the data after it finds a solution.

Which of the following is NOT a type of data validation criteria you can assign to a cell?

The Simplex LP solving method uses geometric progression to solve problems.

An Answer Report's ____ column indicates binding constraints.

Which of the following are methods or tools you can use to solve complex worksheet problems?

When considering an approach to a complex problem in Excel,start with the least complex method of attempting to solve the problem._________________________

Which of the following are error codes?

The ____ feature is especially useful when working with very large worksheets.

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

Working With Large Worksheets, Charting, and What-If Analysis

Financial Functions, Data Tables, and Amortization Schedules

Working With Multiple Worksheets and Workbooks

Creating, Sorting, and Querying a Table

Creating Templates, Importing Data, and Working With Smartart, Images, and Screenshots

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Using Macros and Visual Basic for Applications Vba With Excel

Collaboration Features for Workbooks

Essential Concepts and Skills

Productivity App: Productivity Apps for School and Work

Filters

Exam 9: Formula Auditing, Data Validation, and Complex Problem Solving

____ are named combinations of values that are assigned to variables in a model.

You can attempt to solve a complex worksheet problem manually,also known as the trial and error method.

An Answer Report shows original and final values of the target cell and changing cells plus ____.

The primary uses of the Scenario Manager include all of the following except ​

Which of the following is not a primary use of the Scenario Manager?

Each cell referenced in a formula is a dependent of the cell containing the formula.

You should name ranges for all input variables before creating your first scenario.

When using the Custom data validation type,you can use a formula that evaluates to either true or false.

Which of the following is the path to the Trace Precedents button?

A constraint that is not binding is one that is not a limiting factor in the solution that Goal Seek provides.

The error code #DIV / 0! indicates that there are no common cells in two ranges a formula identifies as having an intersection.

Auditing the formulas in a worksheet can give you insight into how a worksheet is structured.

Solver creates a Summary Solution Report on the same worksheet as the data after it finds a solution.

Which of the following is NOT a type of data validation criteria you can assign to a cell?

The Simplex LP solving method uses geometric progression to solve problems.

An Answer Report's ____ column indicates binding constraints.

Which of the following are methods or tools you can use to solve complex worksheet problems?

When considering an approach to a complex problem in Excel,start with the least complex method of attempting to solve the problem._________________________

Which of the following are error codes?

The ____ feature is especially useful when working with very large worksheets.

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

Working With Large Worksheets, Charting, and What-If Analysis

Financial Functions, Data Tables, and Amortization Schedules

Working With Multiple Worksheets and Workbooks

Creating, Sorting, and Querying a Table

Creating Templates, Importing Data, and Working With Smartart, Images, and Screenshots

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Using Macros and Visual Basic for Applications Vba With Excel

Collaboration Features for Workbooks

Essential Concepts and Skills

Productivity App: Productivity Apps for School and Work

Filters

The primary uses of the Scenario Manager include all of the following except