MOS 2016 Study Guide for Microsoft Excel

Objective group 1. Create and manage worksheets and workbooks

The skills tested in this section of the Microsoft Office Specialist exam for Microsoft Excel 2016 relate to creating and managing workbooks and worksheets. Specifically, the following objectives are associated with this set of skills:

1.1 Create worksheets and workbooks

1.2 Navigate in worksheets and workbooks

1.3 Format worksheets and workbooks

1.4 Customize options and views for worksheets and workbooks

1.5 Configure worksheets and workbooks for distribution

A single workbook can contain a vast amount of raw and calculated data stored on one or more worksheets. The data on a worksheet can be independent, or related to data in other areas of the workbook or in other workbooks.