Exam 12: Templates, styles, and Macros

By default the ________ uses absolute cell references when storing a macro.

Which of the following are not included in themes?

There are many templates available online.

Theme fonts may not be altered.

________ files save with .xltx file extensions.

Where are custom cell styles stored?

The Macro Recorder uses absolute references by default.

Where would you find the Template Gallery?

Formatting is limited in Templates.

By default,________ are locked.

In VBA,everything between and including the two following lines would be the CleanData sub procedure. Sub CleanData() End Sub

How do you insert a button to run a macro in a worksheet?

A user can modify a cell style.

What function traps errors in a custom template?

Protected workbooks cannot be ________.

What would be the first line of the module for a function named Mileage with parameters Miles and Rate?

Where can you delete or run a macro?

What is the file extension for a Macro-Enabled Workbook?

A(n)________ is one that prevents users from editing the contents or formatting.

If you want to place Confidential behind the data in a worksheet,you use a custom ________.