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

Chapter 4. Working with Macros and Forms

The skills tested in this section of the Microsoft Office Expert exam for Microsoft Excel 2010 relate to using macros and forms, including how to record and run a macro and how to insert controls to build a form. Specifically, the following objectives are associated with this set of skills:

4.1 Create and Manipulate Macros

4.2 Insert and Manipulate Form Controls

Important

The topics and procedures in this chapter refer to command groups on the Developer tab. If the Developer tab is not displayed on the ribbon, click Options on the File tab, click Customize Ribbon in the Excel Options dialog box, and then select Developer in the list of main tabs.

4.1 Create and Manipulate Macros

A macro in Excel can perform ...