Deck 9: Exploring Financial Tools and Functions

Question 1

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.

Answer 1

True

Question 2

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.

Answer 2

True

Question 3

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.

Answer 3

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.

Question 5

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.