Question 1

Which of the following is the path to the 'Remove All Arrows' arrow?

Accepted Answer

Question 2

Errors can be less obvious,introduced through formulas which,while technically correct,introduce unintended results to a worksheet.

Accepted Answer

A) True 
 B)False

Question 3

Formula auditing tools include a tracer ____,which is drawn from a cell that appears in a formula in another cell or from a cell that contains a formula with cell references.

Accepted Answer

A)  arrow 
B)  triangle 
C)  link 
D)  none of the above 
A)  arrow 
B)  triangle 
C)  link 
D)  none of the above

Question 4

A Scenario Summary worksheet is a worksheet in outline format.​

Accepted Answer

A) True 
 B)False

Question 5

The ____ allows you to monitor the values and formulas in cells as you work on a worksheet.

Accepted Answer

A)  Show Window 
B)  Data Window 
C)  Watch Window 
D)  Calculation Window 
A)  Show Window 
B)  Data Window 
C)  Watch Window 
D)  Calculation Window

Question 6

The ____ button allows you to move through a formula step by step.

Accepted Answer

A)  Check Formula 
B)  Evaluate Formula 
C)  Review Formula 
D)  Verify Formula 
A)  Check Formula 
B)  Evaluate Formula 
C)  Review Formula 
D)  Verify Formula

Question 7

Solver allows you to set a constraint that includes a cell reference followed by a(n)____.

Accepted Answer

A)  value 
B)  operator 
C)  format 
D)  none of the above 
A)  value 
B)  operator 
C)  format 
D)  none of the above

Question 8

Entries that are the result of calculations will not produce data validation errors.

Accepted Answer

A) True 
 B)False

Question 9

PivotTables summarize large amounts of data,and can be rearranged and regrouped to show the data in various forms.

Accepted Answer

A) True 
 B)False

Question 10

The goal for the Solver feature is to maximize the solution within the constraints set.

Accepted Answer

A) True 
 B)False

Question 11

One of the tools that Excel provides to solve complex problems is ____,which allows you to specify up to 200 cells that can be adjusted to find a solution to a problem.

Accepted Answer

A)  Goal Seek 
B)  Trendlines 
C)  Solver 
D)  Data Solutions 
A)  Goal Seek 
B)  Trendlines 
C)  Solver 
D)  Data Solutions

Question 12

Which of the following is the path to the 'What-If Analysis' button?

Accepted Answer

Question 13

The Trace Error button is located in the ____ dialog box.

Accepted Answer

A)  Error Checking 
B)  Calculation Checking 
C)  Formula Checking 
D)  none of the above 
A)  Error Checking 
B)  Calculation Checking 
C)  Formula Checking 
D)  none of the above

Question 14

Goal seeking allows you to manipulate multiple cells to find an optimal solution to a complex problem.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following is the path to the Data Validation button?

Accepted Answer

Question 16

The Goal Seek command is located on the ____ menu.

Accepted Answer

A)  What-If Analysis 
B)  Problem Solving Tools 
C)  Calculation Settings 
D)  none of the above 
A)  What-If Analysis 
B)  Problem Solving Tools 
C)  Calculation Settings 
D)  none of the above

Question 17

For each model,it is helpful to define a ____ scenario that represents the starting assumptions.

Accepted Answer

A)  baseline 
B)  topline 
C)  bottomline 
D)  sideline 
A)  baseline 
B)  topline 
C)  bottomline 
D)  sideline

Question 18

Which of the following is the path to the Watch Window button?

Accepted Answer

Question 19

To check for invalid data entered as the result of a formula or automated tools such as Goal Seek,use the '____' command.

Accepted Answer

A)  Bold Invalid Data 
B)  Delete Invalid Data 
C)  Circle Invalid Data 
D)  Replace Invalid Data 
A)  Bold Invalid Data 
B)  Delete Invalid Data 
C)  Circle Invalid Data 
D)  Replace Invalid Data

Question 20

Obvious formula errors in a worksheet are indicated by a(n)____ in the cell that contains the formula.

Accepted Answer

A)  error code,such as # / DIV0! 
B)  series of pound signs (#####) 
C)  green triangle 
D)  blue square 
A)  error code,such as # / DIV0! 
B)  series of pound signs (#####) 
C)  green triangle 
D)  blue square

Which of the following is the path to the 'Remove All Arrows' arrow?

Errors can be less obvious,introduced through formulas which,while technically correct,introduce unintended results to a worksheet.

Formula auditing tools include a tracer ____,which is drawn from a cell that appears in a formula in another cell or from a cell that contains a formula with cell references.

A Scenario Summary worksheet is a worksheet in outline format.

The ____ allows you to monitor the values and formulas in cells as you work on a worksheet.

The ____ button allows you to move through a formula step by step.

Solver allows you to set a constraint that includes a cell reference followed by a(n)____.

Entries that are the result of calculations will not produce data validation errors.

PivotTables summarize large amounts of data,and can be rearranged and regrouped to show the data in various forms.

The goal for the Solver feature is to maximize the solution within the constraints set.

One of the tools that Excel provides to solve complex problems is ____,which allows you to specify up to 200 cells that can be adjusted to find a solution to a problem.

Which of the following is the path to the 'What-If Analysis' button?

The Trace Error button is located in the ____ dialog box.

Goal seeking allows you to manipulate multiple cells to find an optimal solution to a complex problem.

Which of the following is the path to the Data Validation button?

The Goal Seek command is located on the ____ menu.

For each model,it is helpful to define a ____ scenario that represents the starting assumptions.

Which of the following is the path to the Watch Window button?

To check for invalid data entered as the result of a formula or automated tools such as Goal Seek,use the '____' command.

Obvious formula errors in a worksheet are indicated by a(n)____ in the cell that contains the formula.

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

Which of the following is the path to the 'Remove All Arrows' arrow?

Errors can be less obvious,introduced through formulas which,while technically correct,introduce unintended results to a worksheet.

Formula auditing tools include a tracer ____,which is drawn from a cell that appears in a formula in another cell or from a cell that contains a formula with cell references.

A Scenario Summary worksheet is a worksheet in outline format.​

The ____ allows you to monitor the values and formulas in cells as you work on a worksheet.

The ____ button allows you to move through a formula step by step.

Solver allows you to set a constraint that includes a cell reference followed by a(n)____.

Entries that are the result of calculations will not produce data validation errors.

PivotTables summarize large amounts of data,and can be rearranged and regrouped to show the data in various forms.

The goal for the Solver feature is to maximize the solution within the constraints set.

One of the tools that Excel provides to solve complex problems is ____,which allows you to specify up to 200 cells that can be adjusted to find a solution to a problem.

Which of the following is the path to the 'What-If Analysis' button?

The Trace Error button is located in the ____ dialog box.

Goal seeking allows you to manipulate multiple cells to find an optimal solution to a complex problem.

Which of the following is the path to the Data Validation button?

The Goal Seek command is located on the ____ menu.

For each model,it is helpful to define a ____ scenario that represents the starting assumptions.

Which of the following is the path to the Watch Window button?

To check for invalid data entered as the result of a formula or automated tools such as Goal Seek,use the '____' command.

Obvious formula errors in a worksheet are indicated by a(n)____ in the cell that contains the formula.

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

A Scenario Summary worksheet is a worksheet in outline format.