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

Question 1

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

A)saved
B)deleted
C)lost
D)altered

Answer 1

D

Question 2

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

A)Excel only
B)all office programs
C)Access only
D)Excel and Access

Answer 2

A

Question 3

The action that causes a macro to run,which may include a combination of keystrokes and the click of a button on the Quick Access Toolbar,is called ________.

A)a sub procedure
B)a module
C)an event
D)a file

Answer 3

C

Question 4

A location where you can store macros that you want to be able to use in other workbooks is the ________.

A)Personal Macro Workbook
B)Visual Basic Workbook
C)Code Group
D)Module

Question 5

If you share macros with others,you can certify them with a ________.

A)trust signature
B)digital signature
C)certify stamp
D)macro stamp

Question 6

You would choose which of the following workbooks to save a macro that is used in other workbooks?

A)Personal Worksheet
B)Personal Workbook
C)Personal Macro Worksheet
D)Personal Macro Workbook

Question 7

Macros are recorded in the ________ programming language,which you can use to write computer programs within the Microsoft Windows environment.

A)Microsoft Operating System
B)Visual Basic for Applications
C)Excel
D)Microsoft Windows 10

Question 8

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

A)external to Excel
B)built into Excel
C)case sensitive
D)used by all applications

Question 9

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

A)worksheet
B)sheet tab
C)cell
D)ribbon

Question 10

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

A)when a workbook is closed
B)when a workbook is opened
C)a double mouse click
D)in a file

Question 11

From the ________ ribbon tab,you can change the macro security settings in Excel.

A)Visual Basic
B)Security
C)Developer
D)Macro

Question 12

You add a button to the Quick Access Toolbar from the ________ dialog box.

A)Commands
B)Backstage view
C)Excel Options
D)Developer

Question 13

To approve or block files containing macros,your macro security level should be set to ________.

A)Enable all macros
B)Disable all macros without notification
C)Enable all macros without files
D)Disable all macros with notification

Question 14

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

A)macro
B)module
C)construct
D)property

Question 15

A worksheet or Excel object containing fields and controls that enable you to easily enter or edit data is ________.

A)a macro
B)a Visual Basic group
C)an expense
D)a form

Question 16

Unauthorized macro code is called a ________.

A)warning code
B)virus code
C)malicious code
D)macro virus

Question 17

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

A)digital signature
B)macro project
C)document certificate
D)macro stamp

Question 18

When naming a macro,the first character of the macro name must be ________.

A)a number
B)a letter
C)a cell reference
D)an underscore

Question 19

Before working with a macro,you must first ________.

A)single out tasks to be completed
B)add the Developer tab to the ribbon
C)build an action
D)close your workbook

Question 20

A function key or key combination,such as F5 or Ctrl + R,that carries out a menu command is called a ________.

A)macro
B)shortcut key
C)dongle
D)click key

Question 21

When coding in VBA,comments are preceded by ________.

A)a double quote
B)a question mark
C)an exclamation point
D)an apostrophe

Question 22

In VBA,comments added to code will display in ________.

A)yellow text
B)green text
C)red text
D)blue text

Question 23

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

A)Design Mode
B)View Mode
C)Control Mode
D)Active Mode

Question 24

On the Categorized tab,the same properties are listed,but they are organized by ________ groups.

A)sorted
B)logical
C)related
D)alphabetized

Question 25

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

A)a procedure
B)a sequence
C)a VBA
D)a module

Question 26

To edit and check VBA code,you would click on View Code from the ________.

A)Edit group
B)Properties group
C)Developer group
D)Controls group

Question 27

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

A)Error Button
B)Fix Button
C)Jump Button
D)Debug button

Question 28

Within VBA,you can write a procedure into your form that will insert ________.

A)an AJAX control
B)an ApplicationX control
C)an ActiveX control
D)a DeveloperX control

Question 29

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

A)View Mode
B)Insert Mode
C)Active Mode
D)Design Mode

Question 30

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

A)helper
B)construct
C)application
D)program

Question 31

A module consists of ________,which are units of computer code that perform some type of action.

A)activities
B)macros
C)procedures
D)controls

Question 32

ActiveX controls are found under which of the following tabs?

A)Developer
B)Review
C)Add-Ins
D)View

Question 33

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

A)a module
B)a function
C)a procedure
D)an ActiveX

Question 34

A set of instructions that accomplish a specific task is called ________.

A)an event
B)a module
C)a construct
D)a sub procedure

Question 35

An ActiveX control is ________,such as a check box or button that is placed on a form to display or enter data,perform an action,or make a form easier to read.

A)an AJAX object
B)a developerX object
C)a design object
D)a graphic object

Question 36

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

A)code window
B)sub procedure
C)VBA construct
D)macro

Question 37

Common uses of ActiveX controls are ________.

A)Disabling content
B)Command buttons,lists,and dialog boxes
C)Starting your computer
D)Testing a procedure

Question 38

The word With denotes the beginning of a ________,an instruction that enables the macro to perform multiple operations on a single object.

A)VBA with
B)VBA constrict
C)VBA construct
D)VBA procedure

Question 39

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

A)module
B)Visual Basic Editor
C)procedure
D)macro

Question 40

When referring to an object in a program,use the ________ field.

A)Cell
B)Name
C)Active
D)Report

Question 41

A macro will record the actions to automate a task.

Question 42

You can record a macro or create a macro by using the Visual Basic Editor.

Question 43

After you add a button to the Quick Access Toolbar,you should test it to ensure that the button performs as you want it to.

Question 44

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

Question 45

A combination of keys to execute a macro or program is known as a shortcut key.

Question 46

To record a macro,a worksheet must be protected.

Question 47

Click the Insert Tab to add a button to the Quick Access Toolbar.

Question 48

Navigation on the ribbon is included in the recorded steps of a macro.

Question 49

A macro is an action or a set of actions with which you can automate tasks by grouping a series of commands into a single command.

Question 50

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

Question 51

To run a macro,you can add a button to the Developer tab.

Question 52

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

Question 53

As your actions are recorded,VBA code is created.

Question 54

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

Question 55

If you make a mistake in entering the code,you will see a Microsoft Visual Basic dialog box informing you of your error.

Question 56

Comments do NOT affect the function of a macro.

Question 57

A module can contain several sub procedures.

Question 58

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

Question 59

To modify a macro,you can modify the actual Visual Basic for Applications code.

Question 60

Visual Basic for Applications (VBA)is the programming language you use to record a macro.

Question 61

Buttons that you add to the Quick Access Toolbar become a ________ part of the toolbar unless you specifically remove the button or reset the Quick Access Toolbar.

Question 62

If you want to change the same property for a group of objects,you can select all objects and change the property.

Question 63

The macro commands are located on the ________tab.

Question 64

An unauthorized programming code in a macro that erases or damages files is called a macro ________.

Question 65

A ________can include an ActiveX control such as a button or check mark that can be placed on a worksheet to display or enter data.

Question 66

A check box is a type of ActiveX control that the person filling in a form can select to indicate a choice.

Question 67

Another name for a procedures or sub procedure is ________.

Question 68

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

Question 69

When assigning a button to the Quick Access Toolbar,go to the Excel ________ dialog box.

Question 70

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

Question 71

The programming language to write computer programs within the Microsoft Windows environment is called ________.

Question 72

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

Question 73

ActiveX controls are NOT attached to cells,instead,they are similar to inserted shapes or SmartArt.

Question 74

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

Question 75

You can store a macro in ________,which is the default setting for the workbook macro.

Question 76

After you add a button to the Quick Access Toolbar,only someone with administrator access can remove it.

Question 77

A macro is an action or set of actions can ________ tasks within Excel.

Question 78

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

Question 79

To record a macro,a worksheet must be ________.

Question 80

The place where VBA programming code is stored when you record a macro is called a ________.