Question 1

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

Accepted Answer

A)  Visual Basic
B)  Security
C)  Developer
D)  MacroE) A) and D)
F) B) and C)

Question 2

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.

Accepted Answer

The answer of Buttons that you add to the Quick...

Question 3

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

Accepted Answer

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

Question 4

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

Accepted Answer

A) True 
 B)False  True

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

Match the following ActiveX Control buttons with their descriptions:
i.Option Button
II.Spin Button
III.Toggle Button
IV.List Box
v.Scroll Bar

Accepted Answer

A)  Inserts a control button that remains pressed in when clicked and then releases when clicked again.
B)  Inserts a control button that allows the user to scroll through a range of values.
C)  Inserts a control button that displays a list of choices.
D)  Inserts a control button that displays a range of numbers from which the user can increase or decrease a value.
E)  Inserts a control button that indicates an on/off choice.F) B) and C)
G) All of the above

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

Match the following terms with their meanings:
i.VBA construct
II.procedure
III.Design Mode
IV.command button
v.restore

Accepted Answer

A)  An Excel feature in which you can add and modify ActiveX controls.
B)  An instruction that enables a macro to perform multiple operations on a single object.
C)  To return something to the condition in which you found it.
D)  An ActiveX control button that runs a macro that performs an action when a user clicks it.
E)  A unit of computer code that performs an action.F) B) and E)
G) None of the above

Question 9

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

Accepted Answer

A)  activities
B)  macros
C)  procedures
D)  controlsE) A) and C)
F) None of the above

Question 10

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

Accepted Answer

The answer of When assigning a button to the Quick...

Question 11

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

Accepted Answer

A) True 
 B)False  True

Question 12

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

Accepted Answer

A)  Commands
B)  Backstage view
C)  Excel Options
D)  DeveloperE) A) and D)
F) A) and C)

Question 13

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

Accepted Answer

A)  Cell
B)  Name
C)  Active
D)  ReportE) A) and C)
F) B) and D) B

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A)  Edit group
B)  Properties group
C)  Developer group
D)  Controls groupE) B) and D)
F) C) and D)

Question 18

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

Accepted Answer

The answer of You can store a macro in ________,which...

Question 19

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

Accepted Answer

A)  yellow text
B)  green text
C)  red text
D)  blue textE) A) and D)
F) All of the above

Question 20

Unauthorized macro code is called a ________.

Accepted Answer

A)  warning code
B)  virus code
C)  malicious code
D)  macro virusE) B) and C)
F) All of the above

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

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedTrue

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

Correct AnswerverifiedShow Answer

Match the following ActiveX Control buttons with their descriptions: i.Option Button II.Spin Button III.Toggle Button IV.List Box v.Scroll Bar

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Match the following terms with their meanings: i.VBA construct II.procedure III.Design Mode IV.command button v.restore

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedTrue

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedB

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Unauthorized macro code is called a ________.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
True

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
True

Correct Answer
verified

Correct Answer
verified
B

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified