Question 1

Which of the following steps must be taken in preparation for working with macros in Excel?

Accepted Answer

A) The DEVELOPER tab must be made available on the ribbon. 
B) A security setting must be modified to enable macros. 
C) All worksheets must be unprotected. 
D) The workbook that includes macros must be saved as an Excel Macro-Enabled Workbook file type. 
A) The DEVELOPER tab must be made available on the ribbon. 
B) A security setting must be modified to enable macros. 
C) All worksheets must be unprotected. 
D) The workbook that includes macros must be saved as an Excel Macro-Enabled Workbook file type. A, B, D

Question 2

You can add up to 15 buttons to the Quick Access Toolbar.

Accepted Answer

A) True 
 B)False  False

Question 3

____ controls require no knowledge of VBA to be used.

Accepted Answer

A)  Dynamic object 
B)  Form 
C)  ActiveX 
D)  Worksheet management 
A)  Dynamic object 
B)  Form 
C)  ActiveX 
D)  Worksheet management B

Question 4

When a user interacts with a control, the Visual Basic code that is associated with that action is executed.

Accepted Answer

A) True 
 B)False

Question 5

-A(n) ____________________ like the one in the accompanying figure is created from a range of cells, and uses the column headings from that range to create the fields on the form.

Accepted Answer

The answer of  
-A(n) ____________________ like the one in...

Question 6

A(n) ____________________ control can have Visual Basic code associated with it that accomplishes more complex actions than a macro or a form button can accommodate.

Accepted Answer

The answer of A(n) ____________________ control can have Visual Basic...

Question 7

You should select the ending cell before turning on the macro recorder.

Accepted Answer

A) True 
 B)False

Question 8

You must enable macros each time you open a workbook containing macros if the macro security setting is 'Disable all macros with notification.'

Accepted Answer

A) True 
 B)False

Question 9

The Protect Sheet button is located on the ____ tab.

Accepted Answer

A)  CODE 
B) PROTECT 
C) DEVELOPER 
D) REVIEW 
A)  CODE 
B) PROTECT 
C) DEVELOPER 
D) REVIEW

Question 10

Which of the following are true about macros?

Accepted Answer

A)  They save time 
B)  They ensure consistency 
C)  They automate repetitive tasks 
D)  They reduce formatting conformity 
A)  They save time 
B)  They ensure consistency 
C)  They automate repetitive tasks 
D)  They reduce formatting conformity

Question 11

Every Excel command and ribbon button has a corresponding Answer Report that the computer executes.

Accepted Answer

A) True 
 B)False

Question 12

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A programming language.

Accepted Answer

A) procedure 
B) macro 
C) VBA 
D) password 
E) computer virus
F)Visual Basic Editor
G)digital certificate
H)desk checking
I)certificate authority
J)ActiveX controls 
A) procedure 
B) macro 
C) VBA 
D) password 
E) computer virus
F)Visual Basic Editor
G)digital certificate
H)desk checking
I)certificate authority
J)ActiveX controls

Question 13

You can press and hold or right-click a sheet tab and then tap or click View Code to open the _________________________ window.

Accepted Answer

The answer of You can press and hold or right-click...

Question 14

You can use the ____ form control to position a set of option buttons together.

Accepted Answer

A)  Group Box 
B)  Spin Button 
C)  Label 
D)  Scroll Bar 
A)  Group Box 
B)  Spin Button 
C)  Label 
D)  Scroll Bar

Question 15

Comments can be placed at any of the following positions EXCEPT ____.

Accepted Answer

A)  in between lines of code 
B)  before the Supplement statement 
C)  at the end of a line of code 
D)  before the Sub statement 
A)  in between lines of code 
B)  before the Supplement statement 
C)  at the end of a line of code 
D)  before the Sub statement

Question 16

If you will be using keyboard navigation when creating a macro, you must ensure that the '____' button in the Code group on the DEVELOPER tab is selected so that the macro works properly.

Accepted Answer

A) Use Relative Reference 
B) Use Absolute Reference 
C) Use Mixed Reference 
D) Use All References 
A) Use Relative Reference 
B) Use Absolute Reference 
C) Use Mixed Reference 
D) Use All References

Question 17

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Have extensive properties that can be used to customize their appearance.

Accepted Answer

A) procedure 
B) macro 
C) VBA 
D) password 
E) computer virus
F)Visual Basic Editor
G)digital certificate
H)desk checking
I)certificate authority
J)ActiveX controls 
A) procedure 
B) macro 
C) VBA 
D) password 
E) computer virus
F)Visual Basic Editor
G)digital certificate
H)desk checking
I)certificate authority
J)ActiveX controls

Question 18

An Excel ____ is a procedure composed of VBA code.

Accepted Answer

A)  micro 
B)  list 
C)  macro 
D)  table 
A)  micro 
B)  list 
C)  macro 
D)  table

Question 19

Navigating to a cell using keyboard navigation in a macro requires the use of _________________________ cell addressing.

Accepted Answer

The answer of Navigating to a cell using keyboard navigation...

Question 20

____ controls provide great flexibility in terms of their design.

Accepted Answer

A)  Option Button 
B)  Form 
C)  Command Button 
D)  ActiveX 
A)  Option Button 
B)  Form 
C)  Command Button 
D)  ActiveX

Which of the following steps must be taken in preparation for working with macros in Excel?

You can add up to 15 buttons to the Quick Access Toolbar.

____ controls require no knowledge of VBA to be used.

When a user interacts with a control, the Visual Basic code that is associated with that action is executed.

-A(n) ____________________ like the one in the accompanying figure is created from a range of cells, and uses the column headings from that range to create the fields on the form.

A(n) ____________________ control can have Visual Basic code associated with it that accomplishes more complex actions than a macro or a form button can accommodate.

You should select the ending cell before turning on the macro recorder.

You must enable macros each time you open a workbook containing macros if the macro security setting is 'Disable all macros with notification.'

The Protect Sheet button is located on the ____ tab.

Which of the following are true about macros?

Every Excel command and ribbon button has a corresponding Answer Report that the computer executes.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A programming language.

You can press and hold or right-click a sheet tab and then tap or click View Code to open the _________________________ window.

You can use the ____ form control to position a set of option buttons together.

Comments can be placed at any of the following positions EXCEPT ____.

If you will be using keyboard navigation when creating a macro, you must ensure that the '____' button in the Code group on the DEVELOPER tab is selected so that the macro works properly.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Have extensive properties that can be used to customize their appearance.

An Excel ____ is a procedure composed of VBA code.

Navigating to a cell using keyboard navigation in a macro requires the use of _________________________ cell addressing.

____ controls provide great flexibility in terms of their design.

Essential Concepts and Skills

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

Working With Large Worksheets, Charting, and What-If Analysis

Working With Multiple Worksheets and Workbooks

Financial Functions, Data Tables, and Amortization Schedules

Creating, Sorting, and Querying a Table

Creating Templates, Manipulating Data, and Adding Additional Enhancements to a Worksheet

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Collaboration Features for Workbooks

Filters

Exam 11: Using Macros and Visual Basic for Applications Vba With Excel

Which of the following steps must be taken in preparation for working with macros in Excel?

You can add up to 15 buttons to the Quick Access Toolbar.

____ controls require no knowledge of VBA to be used.

When a user interacts with a control, the Visual Basic code that is associated with that action is executed.

-A(n) ____________________ like the one in the accompanying figure is created from a range of cells, and uses the column headings from that range to create the fields on the form.

A(n) ____________________ control can have Visual Basic code associated with it that accomplishes more complex actions than a macro or a form button can accommodate.

You should select the ending cell before turning on the macro recorder.

You must enable macros each time you open a workbook containing macros if the macro security setting is 'Disable all macros with notification.'

The Protect Sheet button is located on the ____ tab.

Which of the following are true about macros?

Every Excel command and ribbon button has a corresponding Answer Report that the computer executes.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A programming language.

You can press and hold or right-click a sheet tab and then tap or click View Code to open the _________________________ window.

You can use the ____ form control to position a set of option buttons together.

Comments can be placed at any of the following positions EXCEPT ____.

If you will be using keyboard navigation when creating a macro, you must ensure that the '____' button in the Code group on the DEVELOPER tab is selected so that the macro works properly.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Have extensive properties that can be used to customize their appearance.

An Excel ____ is a procedure composed of VBA code.

Navigating to a cell using keyboard navigation in a macro requires the use of _________________________ cell addressing.

____ controls provide great flexibility in terms of their design.

Essential Concepts and Skills

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

Working With Large Worksheets, Charting, and What-If Analysis

Working With Multiple Worksheets and Workbooks

Financial Functions, Data Tables, and Amortization Schedules

Creating, Sorting, and Querying a Table

Creating Templates, Manipulating Data, and Adding Additional Enhancements to a Worksheet

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Collaboration Features for Workbooks

Filters