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

Part 2. Exam 77-888 Microsoft Excel 2010 Expert

In the next four chapters, you’ll build on the general skills required to create, edit, and format workbooks and worksheets in Microsoft Excel 2010. You’ll learn more about the specific skills you need to be certified as a Microsoft Excel 2010 expert. The areas covered are the following:

• Chapter 1

• Chapter 2

• Chapter 3

• Chapter 4

What You Need to Know

In creating the exercises for this part of the book, we assumed that you are proficient using many of the features in Microsoft Excel 2010. This level of proficiency includes familiarity with features such as conditional formatting, charts and graphs, data types, and data consolidation, as well as familiarity with tasks such as creating named ranges, locking ...