Exam 21: Working With Auditing and Analysis Tools

The Error Checking button is found on the ____ tab.

(Multiple Choice)

4.8/5

(35)

Question 41

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.

(Multiple Choice)

4.8/5

(32)

Question 42

Identify the letter of the choice that best matches the phrase or definition.

A feature that looks for formulas that use data in a selected cell.

Trace Precedents

Useful when you want to find out the result of a scenario based on changing data in several cells.

Trace Error

A feature that locates cells that are used in the formula to assist in identifying the source of the error.

Goal Seek

Correct Answer:

Verified

A feature that looks for formulas that use data in a selected cell.

Useful when you want to find out the result of a scenario based on changing data in several cells.

A feature that locates cells that are used in the formula to assist in identifying the source of the error.

A feature that is used when you need to know the value required to arrive at a specific goal.

A feature that finds the cells that are used in the function.

(Matching)

4.9/5

(42)

Question 43

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

(Multiple Choice)

4.8/5

(37)

Question 44

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

(Multiple Choice)

4.9/5

(31)

Question 45

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.

(True/False)

4.8/5

(38)

Question 46

Showing 41 - 46 of 46

Exam 21: Working With Auditing and Analysis Tools

The Error Checking button is found on the ____ tab.

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 ____ data table uses one function to change cells that use this function.

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

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.

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