Exam 77-420 Microsoft Excel 2013 4. Apply Formulas and Functions 4.1 Apply Cell Ranges and References In Formulas and Functions:  Troubleshoot a formula

Troubleshoot the Formulas 7. What Do You See? The #Value! means that there is an error. Please audit the spreadsheet. Double click on Cell D9.  Excel highlights the cells in this formula:   =D8+B5   How Did That Happen? Part of the formula is still correct. It equals yesterday’s sales—the Cell above—and adds to it. Most formulas automatically use Relative References. A Relative Reference adjusts the the cell references when you copy or fill it down.   In our example,  =D8+B5 becomes =D9+B6 in the next Row down. In Cell D9, the formula adds a number to a label. Hence, the error #Value!