Objective group 4. Perform operations with formulas and functions
The skills tested in this section of the Microsoft Office Specialist exam for Microsoft Excel 2016 relate to the application of functions and formulas. Specifically, the following objectives are associated with this set of skills:
4.1 Summarize data by using functions
4.2 Perform conditional operations by using functions
4.3 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, and express data.
You ...
Get MOS 2016 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.
