MOS 2010 Study Guide for Microsoft® Word Expert, Excel® Expert, Access®, and SharePoint® Exams

Chapter 1. Sharing and Maintaining Workbooks

Many of the skills tested in this section of the Microsoft Office Expert exam for Microsoft Excel 2010 relate to using a workbook in a group, although many apply to work you do on your own as well. Specifically, the following objectives are associated with this set of skills:

1.1 Apply Workbook Settings, Properties, and Data Options

1.2 Apply Protection and Sharing Properties to Workbooks and Worksheets

1.3 Maintain Shared Workbooks

Setting up a workbook that will be used by more than one user often requires a number of steps. This work applies whether a workbook is used by multiple users separately or is set up to be shared and edited by a group of users simultaneously. You might start, for example, ...