Exam 9: Exploring Financial Tools and Functions

Explore all topics

To add cells to the Watch Window, select all cells on a worksheet with formulas, then click Home tab > Editing group > Find & Replace > Go To Special > Formulas tab > Formula Auditing group > Watch Window > Add Watch > Add.

Free

(True/False)

4.8/5

(26)

Question 1

Correct Answer:

Verified

True

To display a tracer arrow to each cell providing direct data to the active cell, click Formulas tab > Formula Auditing group > Trace Precedents.

Free

(True/False)

4.7/5

(40)

Question 2

Correct Answer:

Verified

True

To remove trace arrows in a cell, select the cell, then click Formulas > Arrow beside Remove Arrows > The type of arrow you want to remove from the list.

Free

(True/False)

4.7/5

(34)

Question 3

Correct Answer:

Verified

True

To display a tracer arrow to each cell providing direct data that is dependent on the active cell, click Formulas tab > Formula Auditing group > Trace Dependents.

(True/False)

4.7/5

(44)

Question 4

To evaluate a formula, click the following series: Cell you want to evaluate > Formulas tab > Formula Auditing group > Evaluate Formula > Evaluate (Continue until all the parts of the formula have been evaluated) > Close.

(True/False)

4.9/5

(34)

Question 5

Showing 1 - 5 of 5

To add cells to the Watch Window, select all cells on a worksheet with formulas, then click Home tab > Editing group > Find & Replace > Go To Special > Formulas tab > Formula Auditing group > Watch Window > Add Watch > Add.

To display a tracer arrow to each cell providing direct data to the active cell, click Formulas tab > Formula Auditing group > Trace Precedents.

To remove trace arrows in a cell, select the cell, then click Formulas > Arrow beside Remove Arrows > The type of arrow you want to remove from the list.

To display a tracer arrow to each cell providing direct data that is dependent on the active cell, click Formulas tab > Formula Auditing group > Trace Dependents.

To evaluate a formula, click the following series: Cell you want to evaluate > Formulas tab > Formula Auditing group > Evaluate Formula > Evaluate (Continue until all the parts of the formula have been evaluated) > Close.

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Analyzing Data With Business Intelligence Tools

Exploring Pivottable Design

Developing an Excel Application

Customizing Your Workspace Text and Graphics

Customizing Your Workspace Text and Graphics

Customizing Your Workspace Text and Graphics

Filters