In this video we can discuss about How to use Formula Auditing in Excel Sheet.
Formula auditing group:-
Formula Auditing graphically displays, or traces, the relationships between cells and formulas. Adding tracer arrows lets you visually step through which formulas refer to which cells.
Trace Precedents:-
Draws arrows from all cells that contribute values to the formula result, i.e., active cell (precedents).
Trace Dependents:-
Draws arrows from the active cell to the formula cells, and shows what other cells use the active cell
Remove All Arrows:-
Remove all tracer arrows (both precedent and dependent arrows) at once.
Error Checking:-
Check for errors in a formula using a set of rules to find common mistakes and if there is, the Error Checking dialog box is displayed.