Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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 3

You can prepare a workbook for sharing by clicking the ____ tab in Backstage view.

Accepted Answer

A)  Save & Send 
B)  Options 
C)  Recent 
D)  Info 
A)  Save & Send 
B)  Options 
C)  Recent 
D)  Info

Question 4

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 5

The Circle Invalid Data command is located on the _________________________ menu.

Accepted Answer

The answer of The Circle Invalid Data command is located...

Question 6

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

Accepted Answer

Question 7

Among the various types of validation to be set in the Settings sheet, the _________________________ selection allows you to specify a range that contains a list of valid values for the cell.

Accepted Answer

The answer of Among the various types of validation to...

Question 8

Red ________________________ indicate that one of the referenced cells contains an error.

Accepted Answer

The answer of Red ________________________ indicate that one of the...

Question 9

Which of the following is the path to the Error Checking button?

Accepted Answer

Question 10

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Occurs when one of a cell's defining values is itself.

Accepted Answer

A) formula auditing 
B) data validation 
C) constraint 
D) Scenario Manager 
E) precedent
F)dependent
G)Watch Window
H)circular reference
I)Goal Seek
J)Solver 
A) formula auditing 
B) data validation 
C) constraint 
D) Scenario Manager 
E) precedent
F)dependent
G)Watch Window
H)circular reference
I)Goal Seek
J)Solver

Question 11

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 12

Excel data validation rules apply when you enter data in a cell manually and when a cell's value is calculated by a formula.

Accepted Answer

A) True 
 B)False

Question 13

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A limitation on the possible values that a cell can contain.

Accepted Answer

A) formula auditing 
B) data validation 
C) constraint 
D) Scenario Manager 
E) precedent
F)dependent
G)Watch Window
H)circular reference
I)Goal Seek
J)Solver 
A) formula auditing 
B) data validation 
C) constraint 
D) Scenario Manager 
E) precedent
F)dependent
G)Watch Window
H)circular reference
I)Goal Seek
J)Solver

Question 14

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Each cell referenced in a formula.

Accepted Answer

A) formula auditing 
B) data validation 
C) constraint 
D) Scenario Manager 
E) precedent
F)dependent
G)Watch Window
H)circular reference
I)Goal Seek
J)Solver 
A) formula auditing 
B) data validation 
C) constraint 
D) Scenario Manager 
E) precedent
F)dependent
G)Watch Window
H)circular reference
I)Goal Seek
J)Solver

Question 15

When using Solver, the _________________________ cell contains the optimum value that solves the complex problem given the working constraints.

Accepted Answer

The answer of When using Solver, the _________________________ cell contains...

Question 16

You can use Excel's _________________________ feature to have Excel automatically modify a cell's value in a worksheet in an attempt to reach a certain goal in a dependent cell.

Accepted Answer

The answer of You can use Excel's _________________________ feature to...

Question 17

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 18

Data _________________________ allows you to set cells so that the values they accept are restricted in terms of type and range of data.

Accepted Answer

The answer of Data _________________________ allows you to set cells...

Question 19

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 20

____ is a feature of Excel that allows you to restrict access to workbooks.

Accepted Answer

A)  Workbook Protection Management (WPM) 
B)  Information Rights Management (IRM) 
C)  Shared Workbooks Management (SWM) 
D)  Digital Rights Management (DRM) 
A)  Workbook Protection Management (WPM) 
B)  Information Rights Management (IRM) 
C)  Shared Workbooks Management (SWM) 
D)  Digital Rights Management (DRM)

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

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.

You can prepare a workbook for sharing by clicking the ____ tab in Backstage view.

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

The Circle Invalid Data command is located on the _________________________ menu.

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

Among the various types of validation to be set in the Settings sheet, the _________________________ selection allows you to specify a range that contains a list of valid values for the cell.

Red ________________________ indicate that one of the referenced cells contains an error.

Which of the following is the path to the Error Checking button?

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Occurs when one of a cell's defining values is itself.

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

Excel data validation rules apply when you enter data in a cell manually and when a cell's value is calculated by a formula.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A limitation on the possible values that a cell can contain.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Each cell referenced in a formula.

When using Solver, the _________________________ cell contains the optimum value that solves the complex problem given the working constraints.

You can use Excel's _________________________ feature to have Excel automatically modify a cell's value in a worksheet in an attempt to reach a certain goal in a dependent cell.

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

Data _________________________ allows you to set cells so that the values they accept are restricted in terms of type and range of data.

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

____ is a feature of Excel that allows you to restrict access to workbooks.

Essential Concepts and Skills

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

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

Working With Multiple Worksheets and Workbooks

Financial Functions, Data Tables, and Amortization Schedules

Creating, Sorting, and Querying a Table

Creating Templates, Manipulating Data, and Adding Additional Enhancements to a Worksheet

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

Using Macros and Visual Basic for Applications Vba With Excel

Collaboration Features for Workbooks

Filters

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

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

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.

You can prepare a workbook for sharing by clicking the ____ tab in Backstage view.

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

The Circle Invalid Data command is located on the _________________________ menu.

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

Among the various types of validation to be set in the Settings sheet, the _________________________ selection allows you to specify a range that contains a list of valid values for the cell.

Red ________________________ indicate that one of the referenced cells contains an error.

Which of the following is the path to the Error Checking button?

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Occurs when one of a cell's defining values is itself.

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

Excel data validation rules apply when you enter data in a cell manually and when a cell's value is calculated by a formula.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A limitation on the possible values that a cell can contain.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Each cell referenced in a formula.

When using Solver, the _________________________ cell contains the optimum value that solves the complex problem given the working constraints.

You can use Excel's _________________________ feature to have Excel automatically modify a cell's value in a worksheet in an attempt to reach a certain goal in a dependent cell.

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

Data _________________________ allows you to set cells so that the values they accept are restricted in terms of type and range of data.

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

____ is a feature of Excel that allows you to restrict access to workbooks.

Essential Concepts and Skills

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

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

Working With Multiple Worksheets and Workbooks

Financial Functions, Data Tables, and Amortization Schedules

Creating, Sorting, and Querying a Table

Creating Templates, Manipulating Data, and Adding Additional Enhancements to a Worksheet

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

Using Macros and Visual Basic for Applications Vba With Excel

Collaboration Features for Workbooks

Filters