MOS 2016 Study Guide for Microsoft Excel Expert

Objective group 2. Apply custom data formats and layouts

The skills tested in this section of the Microsoft Office Specialist Expert exam for Microsoft Excel 2016 relate to creating custom number formats, performing data validation, applying conditional formatting, and creating custom styles and theme elements. Specifically, the following objectives are associated with this set of skills:

2.1 Apply custom data formats and validation

2.2 Apply advanced conditional formatting and filtering

2.3 Create and modify custom workbook elements

2.4 Prepare a workbook for internationalization

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 ...