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, ...
Get MOS 2013 Study Guide for Microsoft® Excel® 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.
