MOS 2013 Study Guide for Microsoft® Excel®

Chapter 1. Create and Manage Workbooks and Worksheets

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

1.1 Create workbooks and worksheets

1.2 Navigate through 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 to print or save

An Excel workbook contains one or more worksheets. The data on a worksheet can be related to data in other areas of the workbook or in other workbooks.

A single workbook can contain a vast amount of raw and calculated data. You ...