MOS 2010 Study Guide for Microsoft® Word Expert, Excel® Expert, Access®, and SharePoint® Exams

Chapter 2. Applying Formulas and Functions

The skills tested in this section of the Microsoft Office Expert exam for Microsoft Excel 2010 relate to working with formulas and functions. Specifically, the following objectives are associated with this set of skills:

2.1 Audit Formulas

2.2 Manipulate Formula Options

2.3 Perform Data Summary Tasks

2.4 Apply Functions in Formulas

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 ...