MOS Study Guide for Microsoft Excel Expert Exam MO-201

Objective group 2

Manage and format data

The skills tested in this section of the Microsoft Office Specialist Expert exam for Microsoft Excel 2019 relate to filling cells with data, creating custom number formats, performing data validation, grouping data, inserting subtotals, removing duplicate records, and applying and managing conditional formatting rules. Specifically, the following objectives are associated with this set of skills:

• 2.1 Fill cells based on existing data

• 2.2 Format and validate data

• 2.3 Apply advanced conditional formatting and filtering

Many worksheets are drab, lifeless conglomerations of numbers, formulas, and text. If you’ll be sharing your worksheets with other people, your numbers will have much more impact and will ...