Question 1

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

Accepted Answer

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

Question 2

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

Accepted Answer

A) True 
 B)False  True

Question 3

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

Accepted Answer

A) True 
 B)False  True

Question 4

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 5

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 group 
A) Edit group 
B) Properties group 
C) Developer group 
D) Controls group

Question 6

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

Accepted Answer

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

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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 9

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

Accepted Answer

A) True 
 B)False

Question 10

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 11

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 notification 
A) Enable all macros 
B) Disable all macros without notification 
C) Enable all macros without files 
D) Disable all macros with notification

Question 12

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. 
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.

Question 13

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. 
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.

Question 14

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 15

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

Accepted Answer

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

Question 16

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

Accepted Answer

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

Question 17

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 18

Unauthorized macro code is called a ________.

Accepted Answer

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

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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) controls 
A) activities 
B) macros 
C) procedures 
D) controls

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

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

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

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.

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

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

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

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.

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

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

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

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

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

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

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

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

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

Unauthorized macro code is called a ________.

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

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

Introduction to Microsoft Office 2016 Features

Excell: Creating a Worksheet and Charting Data

Excell: Using Functions, Creating Tables, and Managing Large Workbooks

Excell: Analyzing Data With Pie Charts, Line Charts, and What-If Analysis Tools

Excell: Use Financial and Lookup Functions, Define Names, Validate Data, and Audit Worksheets

Excell: Managing Large Workbooks and Using Advanced Sorting and Filtering

Excell: Creating Charts, Diagrams, and Templates

Excell: Creating Pivottables and Pivotcharts

Excell: Using the Data Analysis, Solver, and Scenario Features, and Building Complex Formulas

Excell: External Data, Database Functions, and Side-By-Side Tables

Excell: Collaborating With Others and Preparing a Workbook for Distribution

Filters

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

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

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

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

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.

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

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

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

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.

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

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

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

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

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

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

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

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

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

Unauthorized macro code is called a ________.

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

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

Introduction to Microsoft Office 2016 Features

Excell: Creating a Worksheet and Charting Data

Excell: Using Functions, Creating Tables, and Managing Large Workbooks

Excell: Analyzing Data With Pie Charts, Line Charts, and What-If Analysis Tools

Excell: Use Financial and Lookup Functions, Define Names, Validate Data, and Audit Worksheets

Excell: Managing Large Workbooks and Using Advanced Sorting and Filtering

Excell: Creating Charts, Diagrams, and Templates

Excell: Creating Pivottables and Pivotcharts

Excell: Using the Data Analysis, Solver, and Scenario Features, and Building Complex Formulas

Excell: External Data, Database Functions, and Side-By-Side Tables

Excell: Collaborating With Others and Preparing a Workbook for Distribution

Filters