Exam 12: Templates, Styles, and Macros

Where would you find the Template Gallery?

Good, Bad, and Neutral are predefined cell styles.

The ________ directs Excel to trust files in particular folders or created by certain users.

Protected workbooks cannot be ________.

Which of the following is not an option in the Trust Center?

What tool is best for automating the completion of repetitive tasks in Excel?

Start a custom function in a new ________.

The background of an Excel Worksheet is always white.

The Themes Gallery is located on the ________ tab.

A(n)________ performs actions on a workbook but doesn't necessarily return a specific value.

What do Miles and Rate represent in the following line of code? Function Mileage (Miles, Rate)

Delete macros in the ________ dialog box.

Cell Styles are on the Page Layout tab.

Where is the New Cell Style command?

Which of the following is a partially completed workbook to be used as a model for a fully completed document?

The IFERROR function traps errors in Excel templates.

You can pause the Macro Recorder in the middle of the recording process to edit mistakes.

The cell styles gallery is on the ________ tab.

It is helpful to provide instructions in a template.