Exam 9: Excell: Using Macros and Visual Basic for Applications

To record a macro,a worksheet must be ________.

A worksheet that contains fields and controls that enables someone to easily enter or edit data is a ________.

A ________ is an instruction that enables the macro to perform multiple operations on a single object.

ActiveX controls are useful for forms that are completed online,because you can control different events that occur when the control is used.

Before working with a macro,you must first ________.

The macro commands are located on the ________tab.

To record a macro,a worksheet must be protected.

When you add and modify Active X controls to a worksheet,you activate which of the following?

A named sequence of statements that performs a task is called ________.

To ________ is to insert something created in one program into another program.

When you add ActiveX controls to your worksheet,you are working in which of the following modes?

ActiveX controls are found under which of the following tabs?

When coding in VBA,comments are preceded by ________.

The Record Macro command records your actions in the Visual Basic for Applications programming language.

If you want to modify the way your macro performs,you can modify the actual code that was created by the macro.

A module can contain several sub procedures.

When using Visual Basic for Applications,modules are automatically stored as a macro.

The Developer tab must be enabled by going to the Backstage view and selecting Customize.

A unit of computer code that performs an action is called ________.

Use caution when assigning a shortcut key to a macro so you do NOT override an existing shortcut within Excel.