MOS 2010 Study Guide for Microsoft Word, Excel, PowerPoint, and Outlook (ISBN 9780735648753) is now available in stores and online . Demonstrate your expertise with Microsoft Office 2010! This all-in-one guide is designed to help you practice and prepare for the four core Microsoft Office Specialist (MOS) exams covering Word, Excel, PowerPoint, and Outlook.   Here is an excerpt from the Excel section of the study guide: 5 Applying Formulas and Functions The skills tested in this section of the Microsoft Office Specialist exam for Microsoft Excel 2010 relate to calculating data by using formulas. Specifically, the following objectives are associated with this set of skills: 5.1 Create Formulas 5.2 Enforce Precedence 5.3 Apply Cell References in Formulas 5.4 Apply Conditional Logic in Formulas more