Question 1

You can open the Properties window by tapping or clicking the Control Properties button ____ in Design mode.

Accepted Answer

Question 2

You can open the VBE Immediate window to debug and execute statements during design by pressing ____.

Accepted Answer

A)  CTRL+I 
B)  CTRL+G 
C)  CTRL+F 
D)  CTRL+J 
A)  CTRL+I 
B)  CTRL+G 
C)  CTRL+F 
D)  CTRL+J

Question 3

Excel passwords are _________________________ sensitive.

Accepted Answer

The answer of Excel passwords are _________________________ sensitive....

Question 4

____ are particularly helpful when working with a series of columns that would otherwise require you to scroll horizontally, or when entering a large number of entries into a worksheet.

Accepted Answer

A)  Control buttons 
B)  Data forms 
C)  Command buttons 
D)  Macro recorders 
A)  Control buttons 
B)  Data forms 
C)  Command buttons 
D)  Macro recorders

Question 5

The basics of using VBA to create a data entry form include ____.

Accepted Answer

A)  adding a button to the Create Code toolbar 
B)  creating a user interface 
C)  setting the properties 
D)  writing the code 
A)  adding a button to the Create Code toolbar 
B)  creating a user interface 
C)  setting the properties 
D)  writing the code

Question 6

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-The manual process of stepping through a procedure's instructions one at a time yourself.

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 7

You can use the _________________________ function to determine the total number of characters in a name.

Accepted Answer

The answer of You can use the _________________________ function to...

Question 8

Excel provides a code generator called a(n) _________________________.

Accepted Answer

The answer of Excel provides a code generator called a(n)...

Question 9

When you work with a ____ created by someone else, you should review its content and structure before you make changes to it.

Accepted Answer

A)  workbook 
B)  document manager 
C)  command line 
D)  dialog report 
A)  workbook 
B)  document manager 
C)  command line 
D)  dialog report

Question 10

You can enable or disable macros with options in the ____ dialog box.

Accepted Answer

A)  Macro Options 
B)  Trust Center 
C)  Excel Options 
D)  Security Center 
A)  Macro Options 
B)  Trust Center 
C)  Excel Options 
D)  Security Center

Question 11

A macro's steps and their order should be determined and rehearsed after creating the macro.

Accepted Answer

A) True 
 B)False

Question 12

Pressing ____ displays formulas in worksheet cells.

Accepted Answer

A)  CTRL+SINGLE QUOTE (') 
B)  CTRL+TILDE (~) 
C)  CTRL+COMMA (,) 
D)  CTRL+ACCENT MARK (`) 
A)  CTRL+SINGLE QUOTE (') 
B)  CTRL+TILDE (~) 
C)  CTRL+COMMA (,) 
D)  CTRL+ACCENT MARK (`)

Question 13

____________________ you create yourself are considered unauthenticated and still will generate a warning when opened if the security level is set to very high, high, or medium.

Accepted Answer

The answer of ____________________ you create yourself are considered unauthenticated...

Question 14

Which of the following is the path to the Macro Security button?

Accepted Answer

Question 15

You can _________________________ a cell containing a formula or function to activate Range Finder.

Accepted Answer

double-tap
double-cl

Question 16

The increased use of networks, the Internet, and email have accelerated the spread of _________________________.

Accepted Answer

The answer of The increased use of networks, the Internet,...

Question 17

If you are looking for the ALT key and do not find it on your on-screen keyboard, you may not have the full virtual keyboard enabled.

Accepted Answer

A) True 
 B)False

Question 18

A ____ ensures that users cannot unprotect a worksheet simply by clicking the Unprotect button.

Accepted Answer

A)  password 
B)  formula 
C)  precedent 
D)  dependent 
A)  password 
B)  formula 
C)  precedent 
D)  dependent

Question 19

Before recording a macro, you should select your ending cell.

Accepted Answer

A) True 
 B)False

Question 20

Each ActiveX control available in the Controls gallery has many ____.

Accepted Answer

A)  properties 
B)  facets 
C)  names 
D)  none of the above 
A)  properties 
B)  facets 
C)  names 
D)  none of the above

You can open the Properties window by tapping or clicking the Control Properties button ____ in Design mode.

You can open the VBE Immediate window to debug and execute statements during design by pressing ____.

Excel passwords are _________________________ sensitive.

____ are particularly helpful when working with a series of columns that would otherwise require you to scroll horizontally, or when entering a large number of entries into a worksheet.

The basics of using VBA to create a data entry form include ____.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -The manual process of stepping through a procedure's instructions one at a time yourself.

You can use the _________________________ function to determine the total number of characters in a name.

Excel provides a code generator called a(n) _________________________.

When you work with a ____ created by someone else, you should review its content and structure before you make changes to it.

You can enable or disable macros with options in the ____ dialog box.

A macro's steps and their order should be determined and rehearsed after creating the macro.

Pressing ____ displays formulas in worksheet cells.

____________________ you create yourself are considered unauthenticated and still will generate a warning when opened if the security level is set to very high, high, or medium.

Which of the following is the path to the Macro Security button?

You can _________________________ a cell containing a formula or function to activate Range Finder.

The increased use of networks, the Internet, and email have accelerated the spread of _________________________.

If you are looking for the ALT key and do not find it on your on-screen keyboard, you may not have the full virtual keyboard enabled.

A ____ ensures that users cannot unprotect a worksheet simply by clicking the Unprotect button.

Before recording a macro, you should select your ending cell.

Each ActiveX control available in the Controls gallery has many ____.

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

You can open the Properties window by tapping or clicking the Control Properties button ____ in Design mode.

You can open the VBE Immediate window to debug and execute statements during design by pressing ____.

Excel passwords are _________________________ sensitive.

____ are particularly helpful when working with a series of columns that would otherwise require you to scroll horizontally, or when entering a large number of entries into a worksheet.

The basics of using VBA to create a data entry form include ____.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -The manual process of stepping through a procedure's instructions one at a time yourself.

You can use the _________________________ function to determine the total number of characters in a name.

Excel provides a code generator called a(n) _________________________.

When you work with a ____ created by someone else, you should review its content and structure before you make changes to it.

You can enable or disable macros with options in the ____ dialog box.

A macro's steps and their order should be determined and rehearsed after creating the macro.

Pressing ____ displays formulas in worksheet cells.

____________________ you create yourself are considered unauthenticated and still will generate a warning when opened if the security level is set to very high, high, or medium.

Which of the following is the path to the Macro Security button?

You can _________________________ a cell containing a formula or function to activate Range Finder.

The increased use of networks, the Internet, and email have accelerated the spread of _________________________.

If you are looking for the ALT key and do not find it on your on-screen keyboard, you may not have the full virtual keyboard enabled.

A ____ ensures that users cannot unprotect a worksheet simply by clicking the Unprotect button.

Before recording a macro, you should select your ending cell.

Each ActiveX control available in the Controls gallery has many ____.

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