Question 1

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

Question 2

Case 9-2
Once each month, the accounting staff meets in the conference room for a catered lunch and a discussion of ways to improve efficiency using the department's software tools. Today's meeting covers a few of Excel's advanced features. As the senior accountant and most experienced Excel user in the department, you have volunteered to mediate the discussion.
-Beth, the sales accountant, is charged with developing the workbooks her two accounting clerks use to record and analyze sales data. She expresses some concern about the number of data entry errors that she finds in the workbooks and asks you if Excel has a feature she can use to help ensure fewer data entry errors. You suggest that she ____.

Accepted Answer

A)  retrain her accounting clerks on the importance of accurate data entry as Excel has no built-in feature to help improve data entry quality 
B)  set data validation rules for the key cells in each worksheet to both prompt the accounting clerk for the type of data to be entered and provide a warning message when invalid data is entered 
C)  train her accounting clerks to use the Document Inspector to identify and correct data entry errors before finalizing each workbook 
D)  use the Scenario Manager to print a report of all data entry errors in each workbook she reviews 
A)  retrain her accounting clerks on the importance of accurate data entry as Excel has no built-in feature to help improve data entry quality 
B)  set data validation rules for the key cells in each worksheet to both prompt the accounting clerk for the type of data to be entered and provide a warning message when invalid data is entered 
C)  train her accounting clerks to use the Document Inspector to identify and correct data entry errors before finalizing each workbook 
D)  use the Scenario Manager to print a report of all data entry errors in each workbook she reviews

Question 3

Goal seeking allows you to manipulate _________________________ cell(s) in order to reach a goal.

Accepted Answer

The answer of Goal seeking allows you to manipulate _________________________...

Question 4

A cell containing a formula that references other cells is said to have ____.

Accepted Answer

A)  dependents 
B)  calculations 
C)  precedents 
D)  references 
A)  dependents 
B)  calculations 
C)  precedents 
D)  references

Question 5

____ 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 6

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 7

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 8

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Gives insight into how a worksheet is structured and how cells are related.

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 9

-Dashed precedent arrows, as shown in the accompanying figure, indicate precedents on _________________________.

Accepted Answer

a differen

Question 10

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 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

Question 13

The Document Inspector dialog box allows you to choose which kinds of content you want to inspect.

Accepted Answer

A) True 
 B)False

Question 14

Entering the formula =B2/A2 in cell B2 creates a(n) _________________________.

Accepted Answer

The answer of Entering the formula =B2/A2 in cell B2...

Question 15

The ____ worksheet generated by the Scenario Manager actually is a worksheet in outline format.

Accepted Answer

A)  Calculation Summary 
B)  Model Summary 
C)  Scenario Summary 
D)  Solution Summary 
A)  Calculation Summary 
B)  Model Summary 
C)  Scenario Summary 
D)  Solution Summary

Question 16

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 17

Which of the following is not a valid consideration when creating scenarios?

Accepted Answer

A)  Exclude cells that contain sheet title, row heading, or column heading text 
B)  Exclude cells that contain formulas 
C)  Exclude cells that remain constant across scenarios 
D)  Exclude cells that are input cells for your model 
A)  Exclude cells that contain sheet title, row heading, or column heading text 
B)  Exclude cells that contain formulas 
C)  Exclude cells that remain constant across scenarios 
D)  Exclude cells that are input cells for your model

Question 18

Before you use IRM, your computer must first be configured with IRM, as should the computers or mobile devices of anyone attempting to use a document that includes IRM features.

Accepted Answer

A) True 
 B)False

Question 19

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 20

If you save the 2013 version of a workbook using the Excel 97-2003 workbook file format without changing the file name, you will overwrite the 2013 version of the workbook.

Accepted Answer

A) True 
 B)False

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

Goal seeking allows you to manipulate _________________________ cell(s) in order to reach a goal.

A cell containing a formula that references other cells is said to have ____.

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

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

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Gives insight into how a worksheet is structured and how cells are related.

-Dashed precedent arrows, as shown in the accompanying figure, indicate precedents on _________________________.

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

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

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

The Document Inspector dialog box allows you to choose which kinds of content you want to inspect.

Entering the formula =B2/A2 in cell B2 creates a(n) _________________________.

The ____ worksheet generated by the Scenario Manager actually is a worksheet in outline format.

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

Which of the following is not a valid consideration when creating scenarios?

Before you use IRM, your computer must first be configured with IRM, as should the computers or mobile devices of anyone attempting to use a document that includes IRM features.

An Answer Report's ____ column indicates binding constraints.

If you save the 2013 version of a workbook using the Excel 97-2003 workbook file format without changing the file name, you will overwrite the 2013 version of the workbook.

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

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

Goal seeking allows you to manipulate _________________________ cell(s) in order to reach a goal.

A cell containing a formula that references other cells is said to have ____.

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

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

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Gives insight into how a worksheet is structured and how cells are related.

-Dashed precedent arrows, as shown in the accompanying figure, indicate precedents on _________________________.

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

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

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

The Document Inspector dialog box allows you to choose which kinds of content you want to inspect.

Entering the formula =B2/A2 in cell B2 creates a(n) _________________________.

The ____ worksheet generated by the Scenario Manager actually is a worksheet in outline format.

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

Which of the following is not a valid consideration when creating scenarios?

Before you use IRM, your computer must first be configured with IRM, as should the computers or mobile devices of anyone attempting to use a document that includes IRM features.

An Answer Report's ____ column indicates binding constraints.

If you save the 2013 version of a workbook using the Excel 97-2003 workbook file format without changing the file name, you will overwrite the 2013 version of the workbook.

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