Chapter 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 5.1 Create Formulas
5.2 5.2 Enforce Precedence
5.3 5.3 Apply Cell References in Formulas
5.4 5.4 Apply Conditional Logic in Formulas
5.5 5.5 Apply Named Ranges in Formulas
5.6 5.6 Apply Cell Ranges in Formulas

Excel has been referred to as the world’s most popular database program because you can store vast amounts of data within a single workbook or worksheet. This was not, however, the purpose for which Excel was created. By using the many functions built in to Excel, you can ...

Get MOS 2010 Study Guide for Microsoft® Word, Excel®, PowerPoint®, and Outlook® now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial