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

You can ________ that the macro is from a trusted source by using a digital signature.

The word that notes the beginning of a VBA construct is ________.

Match the following terms with their meanings: i.Active X Control II.check box III.properties IV.Form control v.embed

The feature in which you can add and modify ActiveX controls is ________ Mode.

The macro recorder records all the steps required to complete the actions you want your macro to perform except for navigation on the ________.

Match the following ActiveX Control buttons with their descriptions: i.Command Button II.Combo Box III.Check Box IV.Image v.More Controls

When you assign a shortcut key to a macro,it will take precedence over the shortcut keys that are ________.

An electronic,encryption-based,secure stamp of authentication on a macro or document is called a ________.

By using a digital signature,you confirm that the document or macro originated from the signer and has NOT been ________.

If you make an error when entering code and need to correct the error,you can click the ________.

ActiveX controls have a set of characteristics or ________ that you can change.

Macros can be performed with a single mouse click,a keyboard shortcut,or ________.

An instruction that enables a macro to perform multiple operations on a single object is called a VBA ________.

To access the ________ window,click the Debug button within the Microsoft Visual Basic dialog box.

The window where you can view and edit the module containing the Visual Basic code is the ________ window.

A collection of VBA declarations,statements,and procedures stored together as one named unit is known as a ________.

Any macro setting changes made in Excel in the Macro Settings category apply to ________.