Question 1

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

Accepted Answer

A)  (FORMULAS tab | Execute Macro group) 
B)  (DEV 
A)  (FORMULAS tab | Execute Macro group) 
B)  (DEV

Question 2

You can use Range Finder or the auditing commands to show which cells are referenced in formulas and functions.

Accepted Answer

A) True 
 B)False

Question 3

Usually all cells in a workbook are unlocked, except for those in which you enter data.

Accepted Answer

A) True 
 B)False

Question 4

Signed macros based on your own digital certificate are called ____.

Accepted Answer

A)  commercially-signed projects 
B)  dynamically managed projects 
C)  self-signed projects 
D)  none of the above 
A)  commercially-signed projects 
B)  dynamically managed projects 
C)  self-signed projects 
D)  none of the above

Question 5

You can change the file type of a workbook that contains macros to Excel Macro-Enabled Workbook in the Trust Center dialog box.

Accepted Answer

A) True 
 B)False

Question 6

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Used by All Office applications to enter, modify, and view 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 7

____ code is created automatically by the macro recorder.

Accepted Answer

A)  ABC 
B)  VBA 
C)  XTM 
D)  RCC 
A)  ABC 
B)  VBA 
C)  XTM 
D)  RCC

Question 8

You can play back a macro, or _________________________ it, as often as you want to repeat the steps you recorded.

Accepted Answer

The answer of You can play back a macro, or...

Question 9

A series of precise instructions for a computer to accomplish a task is called a ____.

Accepted Answer

A)  formula 
B)  description 
C)  procedure 
D)  report 
A)  formula 
B)  description 
C)  procedure 
D)  report

Question 10

Excel's data form feature is used for entering data when the content is straightforward text or numbers.

Accepted Answer

A) True 
 B)False

Question 11

The MACRO tab on the ribbon includes commands used to work with macros.

Accepted Answer

A) True 
 B)False

Question 12

To make a macro available to use in any workbook, you should store the macro in the _________________________.

Accepted Answer

Personal M

Question 13

Which of the following is the default security option for workbooks containing macros?

Accepted Answer

A)  Disable all macros with notification 
B)  Enable all macros 
C)  Disable all macros except digitally signed macros 
D)  Disable all macros without notification 
A)  Disable all macros with notification 
B)  Enable all macros 
C)  Disable all macros except digitally signed macros 
D)  Disable all macros without notification

Question 14

You should test code before you enter it by stepping through the instructions one at a time in a process called ____ checking.

Accepted Answer

A)  procedure 
B)  process 
C)  desk 
D)  instruction 
A)  procedure 
B)  process 
C)  desk 
D)  instruction

Question 15

If you have enabled macros in a worksheet, Excel will not ask you about enabling them the next time you open the worksheet, but will open the worksheet with macros enabled.

Accepted Answer

A) True 
 B)False

Question 16

Which of the following commands can you use to replace a formula with a text value?

Accepted Answer

A)  Paste Text Box 
B)  Paste Summary 
C)  Paste Formulas 
D)  Paste Values 
A)  Paste Text Box 
B)  Paste Summary 
C)  Paste Formulas 
D)  Paste Values

Question 17

Which of the following is the path to the Unprotect Sheet button?

Accepted Answer

Question 18

With a worksheet protected, you can modify the contents of cells regardless of whether they are locked or unlocked.

Accepted Answer

A) True 
 B)False

Question 19

ActiveX controls can be assigned an Excel macro directly.

Accepted Answer

A) True 
 B)False

Question 20

Which of the following are names for a step-by-step description of a computerized task?

Accepted Answer

A)  code 
B)  program 
C)  outline 
D)  procedure 
A)  code 
B)  program 
C)  outline 
D)  procedure

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

You can use Range Finder or the auditing commands to show which cells are referenced in formulas and functions.

Usually all cells in a workbook are unlocked, except for those in which you enter data.

Signed macros based on your own digital certificate are called ____.

You can change the file type of a workbook that contains macros to Excel Macro-Enabled Workbook in the Trust Center dialog box.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Used by All Office applications to enter, modify, and view VBA code.

____ code is created automatically by the macro recorder.

You can play back a macro, or _________________________ it, as often as you want to repeat the steps you recorded.

A series of precise instructions for a computer to accomplish a task is called a ____.

Excel's data form feature is used for entering data when the content is straightforward text or numbers.

The MACRO tab on the ribbon includes commands used to work with macros.

To make a macro available to use in any workbook, you should store the macro in the _________________________.

Which of the following is the default security option for workbooks containing macros?

You should test code before you enter it by stepping through the instructions one at a time in a process called ____ checking.

If you have enabled macros in a worksheet, Excel will not ask you about enabling them the next time you open the worksheet, but will open the worksheet with macros enabled.

Which of the following commands can you use to replace a formula with a text value?

Which of the following is the path to the Unprotect Sheet button?

With a worksheet protected, you can modify the contents of cells regardless of whether they are locked or unlocked.

ActiveX controls can be assigned an Excel macro directly.

Which of the following are names for a step-by-step description of a computerized task?

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 is the path to the Record Macro button?

You can use Range Finder or the auditing commands to show which cells are referenced in formulas and functions.

Usually all cells in a workbook are unlocked, except for those in which you enter data.

Signed macros based on your own digital certificate are called ____.

You can change the file type of a workbook that contains macros to Excel Macro-Enabled Workbook in the Trust Center dialog box.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Used by All Office applications to enter, modify, and view VBA code.

____ code is created automatically by the macro recorder.

You can play back a macro, or _________________________ it, as often as you want to repeat the steps you recorded.

A series of precise instructions for a computer to accomplish a task is called a ____.

Excel's data form feature is used for entering data when the content is straightforward text or numbers.

The MACRO tab on the ribbon includes commands used to work with macros.

To make a macro available to use in any workbook, you should store the macro in the _________________________.

Which of the following is the default security option for workbooks containing macros?

You should test code before you enter it by stepping through the instructions one at a time in a process called ____ checking.

If you have enabled macros in a worksheet, Excel will not ask you about enabling them the next time you open the worksheet, but will open the worksheet with macros enabled.

Which of the following commands can you use to replace a formula with a text value?

Which of the following is the path to the Unprotect Sheet button?

With a worksheet protected, you can modify the contents of cells regardless of whether they are locked or unlocked.

ActiveX controls can be assigned an Excel macro directly.

Which of the following are names for a step-by-step description of a computerized task?

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