O'Reilly logo

MOS 2013 Study Guide for Microsoft® Excel® by Joan Lambert

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 4. Apply Formulas and Functions

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

4.1 Utilize cell ranges and references in formulas and functions
4.2 Summarize data by using functions
4.3 Utilize conditional logic in functions
4.4 Format and modify text by using functions

Simple formulas and more complex functions provide the means to interpret raw data stored in a workbook in meaningful ways. They also provide a useful structure for processing information. You can increase the consistency and reliability of information by using formulas to calculate, evaluate, ...

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