Formula Auditing Option in Ms-Excel

Formula Auditing Option in Ms-Excel

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.

durgaprasad

leave a comment

Create Account



Log In Your Account