Exam 44: Templates, styles, and Macros: Hands-On-Exercise Videos

To make it easier to run a macro,you can assign the macro to ________.

When creating a new workbook,any templates that you create can be displayed by clicking Personal in the New panel.

If you forget the password to a protected worksheet,you can contact Microsoft to get a replacement password to unprotect it.

To automate the task of clear existing values and displaying instructions for users to enter specific data,you would create a(n)________.

You use the Macro ________ to capture your commands,keystrokes,and mouse clicks.

A subprocedure is created using the ________.

The VBA code to bold the contents of cell H7 is ________.

A macro can be assigned to more than one object in a worksheet.

After a macro has been added to a template,you should click Save to save the template with the macro.

A ________ is a predefined set of colors,fonts,lines,and special effects that look good together and can be applied to a workbook.

To protect a worksheet,you click Format in the ________ group.

A ________ is a predefined document structure that defines basic document settings,such as font,margins,and available styles.

An image can be used as a worksheet background.

A cell ________ is a collection of format settings such as font and fill colors,borders,and alignment that is based on the currently selected theme to provide a consistent appearance within a worksheet.

A protected worksheet can consist of both locked and unlocked cells.

When creating a new workbook,you can select a style from the gallery to give your workbook a consistent look.

When you save a workbook as a template,it is automatically saved to the:

The datestamp object,which was written in the hands-on exercise,is an example of a(n)________.