Question 1

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.

Accepted Answer

A) True 
 B)False  True

Question 2

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.

Accepted Answer

A) True 
 B)False  True

Question 3

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.

Accepted Answer

A) True 
 B)False  True

Question 4

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

Accepted Answer

A) True 
 B)False

Question 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.

Accepted Answer

A) True 
 B)False

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.

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

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.

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.(Digital Only).

Introducing Power BI (Digital Only).

Collaborating with Your Team.(Digital Only).

Filters

Exam 9: Exploring Financial Tools and Functions

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.

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

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.

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.(Digital Only).

Introducing Power BI (Digital Only).

Collaborating with Your Team.(Digital Only).

Filters