Exam 77-888: Microsoft Excel Expert 2010 2. Applying Formulas and Functions 2.1. Audit formulas. Formula -> Formula Auditing ->Trace Precedents What If It Doesn't Work? Computer books are very good if everything works and all of the steps are correct.   What happens when it doesn't work? (Besides the usual cussing and complaining...) Here are steps you can take to troubleshoot these formulas.   1. Try It: Audit the Formulas Double Click Cell E63.   2. What Do You See?  The formula will be displayed in Cell E63. Each of the Named Ranges is shown in color. The Range that was defined by the Name should be outlined with the matching color.   Keep going, please...   Memo to Self: The FORMAL way to look for problems is with Formula Auditing.