O'Reilly logo

MOS 2010 Study Guide for Microsoft® Word Expert, Excel® Expert, Access®, and SharePoint® Exams by John Pierce and Geoff Evelyn

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 2. Applying Formulas and Functions

2.1 Audit Formulas

In the following sections, you learn how you can trace and audit the formulas in a worksheet. The procedures you use let you see the relationships between formulas and the cells that feed values to a formula and those that depend on a formula’s result. You’ll learn as well how to identify and trace errors in formulas, locate invalid data, and how to correct formula ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required