Excel 2016 The 30 Most Common Formulas & Features - The Step-By-Step Guide by C.J. Benton

Author:C.J. Benton [Benton, C.J.]
Language: eng
Format: azw3
Published: 2017-05-08T04:00:00+00:00

FEATURE

DEFINITION

Trace Precedents

Traces and displays graphically, with blue arrows, all of the cells a formula is referencing (including)

Trace Dependents

Displays graphically, with blue arrows, all of the formulas (cells) the selected function is dependent on

* * *

Quick Examples:

Trace Precedents

The formula in cell 'B3' is including values in cells 'A2', 'A4', & 'A5':

Trace Dependents

The formula in cell 'C3' is dependent on the formula in 'B3':

* * *

WEB ADDRESS & FILE NAME FOR EXERCISE:

http://bentonexcelbooks.my-free.website/excel-2016

FormulaAuditing.xlsx

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.