MOS 2013 Study Guide for Microsoft® Excel® Expert

Chapter 2. Apply Custom Formats and Layouts

The skills tested in this section of the Microsoft Office Specialist Expert exams for Microsoft Excel 2013 relate to manipulating formatting and layout options. Specifically, the following objectives are associated with this set of skills:

2.1 Apply custom data formats

2.2 Apply advanced conditional formatting and filtering

2.3 Apply custom styles and templates

2.4 Prepare workbooks for internationalization and accessibility

Being a numbers program, Excel provides extensive number-format customization, beyond the extensive complement of built-in formats. You can use conditional formatting to flag critical values, and you can use custom cell styles and themes to store your custom formats.

This chapter ...