Exam 29: Excel: Templates, styles, and Macros

Cells can be locked from the ________ group on the Home tab.

A run time error will occur if a sub procedure is run on a protected workbook.

Custom functions can be created with the macro recorder.

What is the password character limit in Excel?

By default,the macro recorder uses ________ references.

Which of the following is not a predefined cell style category?

Once created,macro buttons cannot be deleted.

Which of the following items is not stored inside VBA modules?

Custom cell styles cannot be removed.

A ________ is a collection of formats that include coordinating colors,fonts,and special effects to provide a stylish appearance.

What is the default file extension for a template?

Which of the following cannot be modified in a custom cell style?

Once created a custom function cannot be edited.

All templates should contain instructions.

What are the benefits if using templates in the workplace?

The Themes gallery is located on the ________ tab.

The maximum number of characters for a password is 255.

Font attributes can be controlled with cell styles.

Where can a macro be deleted?

Custom cell styles are stored in the ________ workbook.