Question 1

The Scenario feature is a type of " what-if " analysis.

Accepted Answer

A) True 
 B)False  True

Question 2

The #DIV/0! error indicates that either the function is dividing by a(n) ____________________ or that cells used in the function have missing data.

Accepted Answer

zero

Question 3

When you use Goal Seek, it focuses on several cells of data.

Accepted Answer

A) True 
 B)False  False

Question 4

FIGURE EX 15-1   In Figure EX 15-1 above, item 1 points to a(n) ____ icon.

Accepted Answer

A)  precedent 
B)  suggestion 
C)  information 
D)  dependent 
A)  precedent 
B)  suggestion 
C)  information 
D)  dependent

Question 5

When should the Error Checking feature be used instead of the Trace Error feature?

Accepted Answer

The Trace Error feature is helpful when

Question 6

Case EX 15-2 Shishir has just started working in a Web design firm. He is responsible for managing the contact information and details of all the clients. The person who worked before Shishir had a number of workbooks for the client data. The feature that Shishir needs to use is found on the ____ tab.

Accepted Answer

A)  Review 
B)  Home 
C)  Data 
D)  Formulas 
A)  Review 
B)  Home 
C)  Data 
D)  Formulas

Question 7

In the Show Error dialog box, you can choose to show the calculation steps to help identify where the problem occurs.

Accepted Answer

A) True 
 B)False

Question 8

When you look at a function in Excel to see if it is correct, you are doing a(n) ____ of that function.

Accepted Answer

A)  test 
B)  check 
C)  manage 
D)  audit 
A)  test 
B)  check 
C)  manage 
D)  audit

Question 9

Consolidating can only be performed in Excel with the Sum and Average functions.

Accepted Answer

A) True 
 B)False

Question 10

After you've created scenarios, the Scenario Manager lets you view them in a formatted report on a separate worksheet.

Accepted Answer

A) True 
 B)False

Question 11

Excel's auditing feature, ____, finds the cells that are used in the function.

Accepted Answer

A)  Goal Seek 
B)  Trace Precedents 
C)  Scenario Manager 
D)  Trace Error 
A)  Goal Seek 
B)  Trace Precedents 
C)  Scenario Manager 
D)  Trace Error

Question 12

The Trace Error feature is helpful when you are just tracing one cell for an error.

Accepted Answer

A) True 
 B)False

Question 13

To open the Scenario Manager dialog box, click the ____ button arrow in the Data Tools group on the Data tab, and then click Scenario Manager.

Accepted Answer

A)  Tracing 
B)  Data Analysis 
C)  Goal Seek 
D)  What-If Analysis 
A)  Tracing 
B)  Data Analysis 
C)  Goal Seek 
D)  What-If Analysis

Question 14

If you select a cell containing data and then click the Trace Dependents button, a(n) ____________________ is drawn from the selected cell pointing to the cell with the function.

Accepted Answer

The answer of If you select a cell containing data...

Question 15

To locate errors with formulas or functions, you can use the Error Checking tool.

Accepted Answer

A) True 
 B)False

Question 16

Case EX 15-2 Shishir has just started working in a Web design firm. He is responsible for managing the contact information and details of all the clients. The person who worked before Shishir had a number of workbooks for the client data. If Shishir wants to bring together the data from the different workbooks into one worksheet, he can ____ the data.

Accepted Answer

A)  track 
B)  consolidate 
C)  trace 
D)  implode 
A)  track 
B)  consolidate 
C)  trace 
D)  implode

Question 17

In Excel, ____ involves bringing data from several worksheets together into one worksheet.

Accepted Answer

A)  consolidating 
B)  auditing 
C)  tracing 
D)  joining 
A)  consolidating 
B)  auditing 
C)  tracing 
D)  joining

Question 18

When you print a worksheet with tracer arrows, the tracer arrows are not printed.

Accepted Answer

A) True 
 B)False

Question 19

When you save a worksheet file, the tracer arrows are saved with the worksheet.

Accepted Answer

A) True 
 B)False

Question 20

When an error is located, the Error Checking dialog box gives you information about the error.

Accepted Answer

A) True 
 B)False

Exam 21: Working With Auditing and Analysis Tools

The Scenario feature is a type of " what-if " analysis.

The #DIV/0! error indicates that either the function is dividing by a(n) ____________________ or that cells used in the function have missing data.

When you use Goal Seek, it focuses on several cells of data.

FIGURE EX 15-1 In Figure EX 15-1 above, item 1 points to a(n) ____ icon.

When should the Error Checking feature be used instead of the Trace Error feature?

In the Show Error dialog box, you can choose to show the calculation steps to help identify where the problem occurs.

When you look at a function in Excel to see if it is correct, you are doing a(n) ____ of that function.

Consolidating can only be performed in Excel with the Sum and Average functions.

After you've created scenarios, the Scenario Manager lets you view them in a formatted report on a separate worksheet.

Excel's auditing feature, ____, finds the cells that are used in the function.

The Trace Error feature is helpful when you are just tracing one cell for an error.

To open the Scenario Manager dialog box, click the ____ button arrow in the Data Tools group on the Data tab, and then click Scenario Manager.

If you select a cell containing data and then click the Trace Dependents button, a(n) ____________________ is drawn from the selected cell pointing to the cell with the function.

To locate errors with formulas or functions, you can use the Error Checking tool.

In Excel, ____ involves bringing data from several worksheets together into one worksheet.

When you print a worksheet with tracer arrows, the tracer arrows are not printed.

When you save a worksheet file, the tracer arrows are saved with the worksheet.

When an error is located, the Error Checking dialog box gives you information about the error.

Microsoft Access Basics

Creating a Database

Creating Queries

Creating and Modifying Forms

Creating and Modifying Reports

Integrating Access

Enhancing Table Design

Using Advanced Queries

Using Advanced Form Features

Adding Advanced Features to Reports

Creating and Running Macros

Automating Database Processes

Programming in Access

Creating Database Security and Documentation

Microsoft Excel Basics

Using Advanced Chart Features

Improving Data Accuracy

Creating Pivottables and Pivotcharts

Using Powerful Excel Functions

Creating and Using Macros

Protecting, Tracking, and Sharing Workbooks

Importing and Exporting Data

Changing the Appearance of a Worksheet

Organizing the Worksheet

Entering Worksheet Formulas

Using Functions

Enhancing a Worksheet

Working With Multiple Worksheets and Workbooks

Working With Charts

Applying Advanced Formats to Worksheets

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Sharing and Delivering Presentations

Creating Enhancing Powerpoint Presentations

Working With Visual Elements

Expanding on Powerpoint Basics

Editing and Formatting Slide Content

Working With Tables and Charts

Working With Visual and Sound Objects

Customizing Slides

Importing and Exporting Information

Microsoft Word Basics

Working With Templates and Styles

Customizing Tables and Creating Charts

Creating Mail Merge Documents

Sharing Documents

Working With Long Documents

Creating Indexes and Tables of Contents, Figures, and Authorities

Working With Long Documents

Creating Indexes and Tables of Contents, Figures, and Authorities

Basic Editing

Helpful Word Features

Formatting Text

Formatting Paragraphs and Documents

Working With Graphics

Working With Documents

Increasing Efficiency Using Word

Enhancing Documents

Filters