Skip to content
Gallery
WGU: BS in IT
Introduction to IT D322
Principles of Management C483
Business of IT – Applications D336
Organizational Leadership - C484
Spreadsheets - C268
Web Development: Foundations - D276
User Interface Design C773
Web Development: Applications
Project Management - C324
Information Systems Management - C724
Data Management Foundations - D426
Share
Explore
Section 3: References & Calculations

icon picker
3.4 Formula Auditing

Makiel [Muh-Keel]
Last edited 487 days ago by Makiel [Muh-Keel].
Unfortunately, the errors we make are not always evident or easy to track down. Often, the best way to discover the source of an error is to visually inspect the formulas and functions we have created.
The troubleshooting features of Excel are available in the "Formula Auditing" section of the "Formulas" tab.
⁠
image.png
⁠
⁠

Trace Precedents

Feature allows you to see which cells are referenced in a particular formula or function.
⁠
image.png
⁠
⁠

Trace Dependents

Feature allows you to see which other cells reference a particular cell.
⁠
image.png
⁠
⁠

Show Formulas

Feature displays the functions and formulas used in each cell of a worksheet instead of the formula or function results.
⁠
image.png
⁠
⁠

Trace Precedents
Trace Dependents
Show Formulas
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.