Question 1

The ____ error code indicates that a cell reference in a formula is not valid.

Accepted Answer

A)  #DIV / 0! 
B)  #NAME? 
C)  #VALUE! 
D)  #REF! 
A)  #DIV / 0! 
B)  #NAME? 
C)  #VALUE! 
D)  #REF! D

Question 2

When a cell contains a(n)____ reference,it means that one of its defining values is itself.

Accepted Answer

A)  formatted 
B)  circular 
C)  error 
D)  connecting 
A)  formatted 
B)  circular 
C)  error 
D)  connecting B

Question 3

Which of the following is the path to the Solver button?

Accepted Answer

Question 4

Errors can be introduced into a worksheet in formulas.

Accepted Answer

A) True 
 B)False

Question 5

The Show Iteration Results check box is located in the ____ dialog box.

Accepted Answer

A)  Goal Seek solution 
B)  Data Validation Rules 
C)  Add Scenarios 
D)  Solver Parameters 
A)  Goal Seek solution 
B)  Data Validation Rules 
C)  Add Scenarios 
D)  Solver Parameters

Question 6

A(n)____ Report shows the answer that Solver found,which constraints were in place,and which values in the worksheet Solver manipulated in order to solve the problem within those constraints.

Accepted Answer

A)  Solution 
B)  Resolution 
C)  Answer 
D)  Calculation 
A)  Solution 
B)  Resolution 
C)  Answer 
D)  Calculation

Question 7

Which of the following is NOT an issue that must be kept in mind when using Solver?

Accepted Answer

A)  The constraints may be constructed so that an answer that satisfies all of them cannot be found 
B)  Multiple answers might solve the problem 
C)  Some problems do not have solutions 
D)  Constraint precision is incompatible with most forms of automatic scaling 
A)  The constraints may be constructed so that an answer that satisfies all of them cannot be found 
B)  Multiple answers might solve the problem 
C)  Some problems do not have solutions 
D)  Constraint precision is incompatible with most forms of automatic scaling

Question 8

Formula ____ allows you to examine formulas to determine which cells are referenced by those formulas.

Accepted Answer

A)  calculating 
B)  auditing 
C)  formatting 
D)  trending 
A)  calculating 
B)  auditing 
C)  formatting 
D)  trending

Question 9

If you show a scenario and change values on the scenario worksheet,it is the same as changing the scenario.

Accepted Answer

A) True 
 B)False

Question 10

Which of the following complex problem solving methods,features,or options allows you to provide Excel with all of the known rules of your problem as well as the goal you are seeking,and then attempts as many different solutions to the problem as possible?

Accepted Answer

A)  Trial and error method 
B)  Solver feature 
C)  Goal Seek feature 
D)  Enable iterative calculations option 
A)  Trial and error method 
B)  Solver feature 
C)  Goal Seek feature 
D)  Enable iterative calculations option

Question 11

The Scenario Manager command is located on the ____ menu.

Accepted Answer

A)  Data Tools 
B)  Formula Auditing 
C)  Scenarios 
D)  What-If Analysis 
A)  Data Tools 
B)  Formula Auditing 
C)  Scenarios 
D)  What-If Analysis

Question 12

A cell whose value relies on another referenced cell is said to be a(n)____ of that referenced cell.

Accepted Answer

A)  precedent 
B)  partner 
C)  example 
D)  dependent 
A)  precedent 
B)  partner 
C)  example 
D)  dependent

Question 13

A(n)precedent is a limitation on the possible values that a cell can contain._________________________

Accepted Answer

A) True 
 B)False

Question 14

When trying to solve some problems,you can make a(n)educated guess if you are familiar with the data and the structure of the workbook._________________________

Accepted Answer

A) True 
 B)False

Question 15

A Solver constraint that is binding is one that limits the final solution in some way.

Accepted Answer

A) True 
 B)False

Question 16

The ____ Window button opens a separate window that displays values and formulas for specific cells that you choose to monitor.

Accepted Answer

A)  Formula 
B)  Watch 
C)  Error 
D)  Monitoring 
A)  Formula 
B)  Watch 
C)  Error 
D)  Monitoring

Question 17

Which of the following are types of error styles?

Accepted Answer

A)  Stop 
B)  Arrow 
C)  Warning 
D)  Information 
A)  Stop 
B)  Arrow 
C)  Warning 
D)  Information

Question 18

Identifying ____ highlights where changes will occur in the worksheet as a result of changing the value in the cell you are identifying as a referenced cell.

Accepted Answer

A)  precedents 
B)  dependents 
C)  examples 
D)  relationships 
A)  precedents 
B)  dependents 
C)  examples 
D)  relationships

Question 19

The only way to switch between scenarios is to use the Scenario Manager.

Accepted Answer

A) True 
 B)False

Question 20

Excel uses the Calculate Formulas button to move through a formula step by step.

Accepted Answer

A) True 
 B)False

The ____ error code indicates that a cell reference in a formula is not valid.

When a cell contains a(n)____ reference,it means that one of its defining values is itself.

Which of the following is the path to the Solver button?

Errors can be introduced into a worksheet in formulas.

The Show Iteration Results check box is located in the ____ dialog box.

A(n)____ Report shows the answer that Solver found,which constraints were in place,and which values in the worksheet Solver manipulated in order to solve the problem within those constraints.

Which of the following is NOT an issue that must be kept in mind when using Solver?

Formula ____ allows you to examine formulas to determine which cells are referenced by those formulas.

If you show a scenario and change values on the scenario worksheet,it is the same as changing the scenario.

Which of the following complex problem solving methods,features,or options allows you to provide Excel with all of the known rules of your problem as well as the goal you are seeking,and then attempts as many different solutions to the problem as possible?

The Scenario Manager command is located on the ____ menu.

A cell whose value relies on another referenced cell is said to be a(n)____ of that referenced cell.

A(n)precedent is a limitation on the possible values that a cell can contain._________________________

When trying to solve some problems,you can make a(n)educated guess if you are familiar with the data and the structure of the workbook._________________________

A Solver constraint that is binding is one that limits the final solution in some way.

The ____ Window button opens a separate window that displays values and formulas for specific cells that you choose to monitor.

Which of the following are types of error styles?

Identifying ____ highlights where changes will occur in the worksheet as a result of changing the value in the cell you are identifying as a referenced cell.

The only way to switch between scenarios is to use the Scenario Manager.

Excel uses the Calculate Formulas button to move through a formula step by step.

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

The ____ error code indicates that a cell reference in a formula is not valid.

When a cell contains a(n)____ reference,it means that one of its defining values is itself.

Which of the following is the path to the Solver button?

Errors can be introduced into a worksheet in formulas.

The Show Iteration Results check box is located in the ____ dialog box.

A(n)____ Report shows the answer that Solver found,which constraints were in place,and which values in the worksheet Solver manipulated in order to solve the problem within those constraints.

Which of the following is NOT an issue that must be kept in mind when using Solver?

Formula ____ allows you to examine formulas to determine which cells are referenced by those formulas.

If you show a scenario and change values on the scenario worksheet,it is the same as changing the scenario.

Which of the following complex problem solving methods,features,or options allows you to provide Excel with all of the known rules of your problem as well as the goal you are seeking,and then attempts as many different solutions to the problem as possible?

The Scenario Manager command is located on the ____ menu.

A cell whose value relies on another referenced cell is said to be a(n)____ of that referenced cell.

A(n)precedent is a limitation on the possible values that a cell can contain._________________________

When trying to solve some problems,you can make a(n)educated guess if you are familiar with the data and the structure of the workbook._________________________

A Solver constraint that is binding is one that limits the final solution in some way.

The ____ Window button opens a separate window that displays values and formulas for specific cells that you choose to monitor.

Which of the following are types of error styles?

Identifying ____ highlights where changes will occur in the worksheet as a result of changing the value in the cell you are identifying as a referenced cell.

The only way to switch between scenarios is to use the Scenario Manager.

Excel uses the Calculate Formulas button to move through a formula step by step.

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