Exam 21: Working With Auditing and Analysis Tools

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

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

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

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.

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

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.

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

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

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

To ____________________ means to combine or unite.

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

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.

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

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

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.

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.

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

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

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

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.