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

DOWNLOAD PDF
DOWNLOAD AZW3

Author:C.J. Benton [Benton, C.J.]
Language: eng
Format: azw3 + pdf
Published: 2019-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

#evba #etipfree #eama #kingexcel

📤How to Download ebooks: https://www.evba.info/2020/02/instructions-for-downloading-documents.html?m=1