Question 1

Macros are known carriers of ____ because of the ease with which a person can add programming code to them.

Accepted Answer

A)  viruses 
B)  beacons 
C)  errors 
D)  agents 
A)  viruses 
B)  beacons 
C)  errors 
D)  agents

Question 2

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-You can obtain a digital certificate from this.

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 3

Cells must be locked and the worksheet unprotected to restrict what users can do to cell contents.

Accepted Answer

A) True 
 B)False

Question 4

If you make a mistake while recording a macro, press the ESC key and repeat the step in error.

Accepted Answer

A) True 
 B)False

Question 5

You can use the options in the ____ dialog box to apply colors and patterns to make controls stand out more.

Accepted Answer

A)  Format Borders and Fill 
B)  Format Control 
C)  Format Object 
D)  Format Options 
A)  Format Borders and Fill 
B)  Format Control 
C)  Format Object 
D)  Format Options

Question 6

_________________________ a macro causes Excel to step through all of the recorded steps just as they were recorded.

Accepted Answer

The answer of _________________________ a macro causes Excel to step...

Question 7

Comments added to code begin with the word __________________________ or an apostrophe.

Accepted Answer

The answer of Comments added to code begin with the...

Question 8

If you assign the _________________________ keyboard shortcut keys to a macro, you will no longer be able to use the shortcut keys for their original purpose, to copy selected content.

Accepted Answer

The answer of If you assign the _________________________ keyboard shortcut...

Question 9

Because Excel does not have a command or button for every possible worksheet task, Microsoft has included a powerful programming language called HTML 5.

Accepted Answer

A) True 
 B)False

Question 10

You can delete a control by pressing and holding or right-clicking the control and selecting ____ on the shortcut menu.

Accepted Answer

A)  Delete 
B)  Remove 
C)  Cut 
D)  Edit 
A)  Delete 
B)  Remove 
C)  Cut 
D)  Edit

Question 11

It is good practice to place comments containing overall documentation and information before the ____ statement.

Accepted Answer

A)  Sub 
B)  Supplement 
C)  Public 
D)  Rem 
A)  Sub 
B)  Supplement 
C)  Public 
D)  Rem

Question 12

How do you familiarize yourself with a workbook created by someone else?

Accepted Answer

You should review the content and struct

Question 13

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A procedure comprised of VBA code.

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 14

Excel includes a(n) ________________________ that can record a series of actions and save them as a macro.

Accepted Answer

The answer of Excel includes a(n) ________________________ that can record...

Question 15

A macro name can contain numbers and letters but not underscores.

Accepted Answer

A) True 
 B)False

Question 16

If you are confident of the source (author) of a workbook and its macros, tap or click the _________________________ button on the SECURITY WARNING bar.

Accepted Answer

The answer of If you are confident of the source...

Question 17

Which of the following functions can you use to convert names entered in all uppercase to mixed case?

Accepted Answer

A)  CASE 
B)  TEXT 
C)  UPPER 
D)  PROPER 
A)  CASE 
B)  TEXT 
C)  UPPER 
D)  PROPER

Question 18

The process of writing a procedure is called _________________________.

Accepted Answer

computer p

Question 19

Use macros to ensure consistency in all of the following EXCEPT ____.

Accepted Answer

A)  calculations 
B)  formatting 
C)  manipulation of nonnumeric data 
D)  variables 
A)  calculations 
B)  formatting 
C)  manipulation of nonnumeric data 
D)  variables

Question 20

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-An attachment to a file or email message that vouches for its authenticity, for example.

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

Macros are known carriers of ____ because of the ease with which a person can add programming code to them.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -You can obtain a digital certificate from this.

Cells must be locked and the worksheet unprotected to restrict what users can do to cell contents.

If you make a mistake while recording a macro, press the ESC key and repeat the step in error.

You can use the options in the ____ dialog box to apply colors and patterns to make controls stand out more.

_________________________ a macro causes Excel to step through all of the recorded steps just as they were recorded.

Comments added to code begin with the word __________________________ or an apostrophe.

If you assign the _________________________ keyboard shortcut keys to a macro, you will no longer be able to use the shortcut keys for their original purpose, to copy selected content.

Because Excel does not have a command or button for every possible worksheet task, Microsoft has included a powerful programming language called HTML 5.

You can delete a control by pressing and holding or right-clicking the control and selecting ____ on the shortcut menu.

It is good practice to place comments containing overall documentation and information before the ____ statement.

How do you familiarize yourself with a workbook created by someone else?

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A procedure comprised of VBA code.

Excel includes a(n) ________________________ that can record a series of actions and save them as a macro.

A macro name can contain numbers and letters but not underscores.

If you are confident of the source (author) of a workbook and its macros, tap or click the _________________________ button on the SECURITY WARNING bar.

Which of the following functions can you use to convert names entered in all uppercase to mixed case?

The process of writing a procedure is called _________________________.

Use macros to ensure consistency in all of the following EXCEPT ____.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -An attachment to a file or email message that vouches for its authenticity, for example.

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

Macros are known carriers of ____ because of the ease with which a person can add programming code to them.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -You can obtain a digital certificate from this.

Cells must be locked and the worksheet unprotected to restrict what users can do to cell contents.

If you make a mistake while recording a macro, press the ESC key and repeat the step in error.

You can use the options in the ____ dialog box to apply colors and patterns to make controls stand out more.

_________________________ a macro causes Excel to step through all of the recorded steps just as they were recorded.

Comments added to code begin with the word __________________________ or an apostrophe.

If you assign the _________________________ keyboard shortcut keys to a macro, you will no longer be able to use the shortcut keys for their original purpose, to copy selected content.

Because Excel does not have a command or button for every possible worksheet task, Microsoft has included a powerful programming language called HTML 5.

You can delete a control by pressing and holding or right-clicking the control and selecting ____ on the shortcut menu.

It is good practice to place comments containing overall documentation and information before the ____ statement.

How do you familiarize yourself with a workbook created by someone else?

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A procedure comprised of VBA code.

Excel includes a(n) ________________________ that can record a series of actions and save them as a macro.

A macro name can contain numbers and letters but not underscores.

If you are confident of the source (author) of a workbook and its macros, tap or click the _________________________ button on the SECURITY WARNING bar.

Which of the following functions can you use to convert names entered in all uppercase to mixed case?

The process of writing a procedure is called _________________________.

Use macros to ensure consistency in all of the following EXCEPT ____.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -An attachment to a file or email message that vouches for its authenticity, for example.

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