MOS Study Guide for Microsoft Excel Exam MO-200

Objective group 4

Perform operations by using formulas and functions

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

• 4.1 Insert references in formulas

• 4.2 Calculate and transform data 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 ...