Deck 21: Working With Auditing and Analysis Tools

Question 1

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

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

Answer 1

B

Question 2

You can consolidate data from several worksheets in the same workbook or between several workbooks.

Answer 2

True

Question 3

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

Answer 3

False

Question 4

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

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

Question 5

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

Question 6

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

Question 7

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

Question 8

____ refer to cells that supply the values used in a function.

A) Parents
B) Precedents
C) Children
D) Supporters

Question 9

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

Question 10

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

Question 11

You can use the ____ feature when you want to project the results of a function in several cells, not just the one cell containing the function.

A) Goal Seek
B) Data Table
C) Trace Dependents
D) Trace Precedents

Question 12

If you click a cell that has a SUM function and then click the ____ button, the cells that are used in this function are surrounded by a border.

A) Goal Seek
B) Trace Precedents
C) Trace Dependents
D) What-If

Question 13

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

Question 14

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

Question 15

The data that you consolidate in Excel needs to be in the exact location in each of the worksheets.

Question 16

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

Question 17

After you click the Trace Dependents or Trace Precedents buttons, you can remove the tracer arrows by clicking the Delete Arrows button in the Formula Auditing group.

Question 18

If you enter an Average function in a cell but #DIV/0! appears instead, the calculation includes an error.

Question 19

When you audit something, you are checking it for accuracy.

Question 20

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

Question 21

A ____ data table uses one function to change cells that use this function.

A) one-way
B) one-function
C) simple
D) direct

Question 22

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

A) track line
B) data line
C) source arrow
D) tracer arrow

Question 23

To open the Data Table dialog box, click the Data tab, click the ____ button in the Data Tools group, and then click Data Table.

A) Data Validation
B) Text to Columns
C) What-If Analysis
D) Consolidate

Question 24

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.

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

Question 25

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.

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

Question 26

To use the Trace Precedents feature, click the ____ tab, and then click the Trace Precedents button in the Formula Auditing group.

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

Question 27

The ____________________ feature is useful if you want to confirm that the cells you intended to use in the function are in fact used by the function or if the result of a function does not look correct.

Question 28

The What-If Analysis arrow button is found on the ____ tab.

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

Question 29

Case EX 15-1 Tracy is currently living in a rental apartment but she wants to buy a condo. She is using a worksheet to figure out how much she would need to save each year to be able to save enough money to make the down payment for the condo in six years. Tracy was told by her banker that she would need to put down $30,000 for the down-payment on the condo. She can use the ____ feature to figure out how much she would need to save each month to be able to make the down-payment in six years.

A) Trace Dependents
B) Trace Precedents
C) Plan Ahead
D) Goal Seek

Question 30

The Error Checking button is found on the ____ tab.

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

Question 31

Case EX 15-1 Tracy is currently living in a rental apartment but she wants to buy a condo. She is using a worksheet to figure out how much she would need to save each year to be able to save enough money to make the down payment for the condo in six years. The feature that Tracy needs to use is found on the ____ tab.

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

Question 32

The ____ feature works by locating formulas and/or functions that depend on the value in a selected cell.

A) Trace Dependents
B) Trace Precedents
C) Goal Seek
D) Trace Error

Question 33

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

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

Question 34

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.

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

Question 35

The ____ button gives you the option to remove the Trace Dependents tracer arrows, the Trace Precedents tracer arrows, or all the tracer arrows.

A) Delete Arrows
B) Remove Arrows
C) Delete Lines
D) Remove Tracers

Question 36

Excel displays a(n) ____ icon next to the cell with an error status.

A) status
B) information
C) error
D) warning

Question 37

If you click a cell that has a SUM function and then click the Trace Precedents button, an arrow called a(n) ____ is drawn to the cell with the SUM function.

A) tracer arrow
B) track line
C) source arrow
D) error line

Question 38

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

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

Question 39

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

A) trace
B) suggestion
C) view
D) error

Question 40

The ____ performs a "what-if" analysis that lets you change several cells of data.

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

Question 41

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

Question 43

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

Question 44

To ____________________ means to combine or unite.

Question 45

The Goal Seek feature is referred to as a(n) "____________________" analysis tool.

Question 46

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.