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

Answer 3

True

Question 4

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.

Question 5

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