Question 1

A ____ is an attachment to a file or email message that vouches for its authenticity.

Accepted Answer

A)  digital comment 
B)  digital certificate 
C)  certification authority 
D)  digital signature 
A)  digital comment 
B)  digital certificate 
C)  certification authority 
D)  digital signature

Question 2

You can click the Stop/Start Macro button on the status bar to start or stop recording a macro.

Accepted Answer

A) True 
 B)False

Question 3

Briefly discuss the four Macro setting options in the Macro Settings tab in the Trust Center dialog box.

Accepted Answer

Excel provides four levels of protection

Question 4

Form controls and ActiveX controls look identical and function in the same way.

Accepted Answer

A) True 
 B)False

Question 5

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A potentially damaging computer program.

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 6

A(n) ____________________ is a digital signature that is displayed when you email a document from Excel.

Accepted Answer

file digit

Question 7

Excel has a command or button for every possible worksheet task.

Accepted Answer

A) True 
 B)False

Question 8

Case 10-1
You work for several accountants who are hosting a public seminar on recent changes to tax law that are applicable to the new tax year. You and two of your coworkers are tasked with automating the seminar participants' sign-in process by creating a sign-in form in an Excel workbook (based on a workbook created by a previous team) and a macro. Today you and your coworkers are holding a 'brainstorming session' in preparation for creating the form.
-Bob, who has never before attempted to automate a worksheet task, asks how the team can ensure that participants signing in using the data entry form cannot accidentally or purposely make changes to the form. You tell the team ____.

Accepted Answer

A)  not to worry about accidental or purposeful changes to the form; participants can be trusted not to make changes 
B)  that the new company intern will stand by to monitor all participants' data entry and make sure no changes are made to the form 
C)  that a special software patch will be added to Excel to protect the worksheet from changes 
D)  that the data entry form worksheet will be password protected 
A)  not to worry about accidental or purposeful changes to the form; participants can be trusted not to make changes 
B)  that the new company intern will stand by to monitor all participants' data entry and make sure no changes are made to the form 
C)  that a special software patch will be added to Excel to protect the worksheet from changes 
D)  that the data entry form worksheet will be password protected

Question 9

If you are uncertain about the reliability of the source of a workbook and its macros, you can work with the macros disabled, which means that the code is not executable.

Accepted Answer

A) True 
 B)False

Question 10

An event-driven program includes procedures that are executed when specific actions are taken by the user or other events occur.

Accepted Answer

A) True 
 B)False

Question 11

-The ____ shown in the accompanying figure is used by all Office applications to enter, modify, and view Visual Basic for Applications code.

Accepted Answer

A)  Visual Basic Recorder 
B)  Visual Basic Interpreter 
C)  Visual Basic Editor 
D)  none of the above 
A)  Visual Basic Recorder 
B)  Visual Basic Interpreter 
C)  Visual Basic Editor 
D)  none of the above

Question 12

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Another term that means a program or 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

A ____ is an attachment to a file or email message that vouches for its authenticity.

You can click the Stop/Start Macro button on the status bar to start or stop recording a macro.

Briefly discuss the four Macro setting options in the Macro Settings tab in the Trust Center dialog box.

Form controls and ActiveX controls look identical and function in the same way.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A potentially damaging computer program.

A(n) ____________________ is a digital signature that is displayed when you email a document from Excel.

Excel has a command or button for every possible worksheet task.

If you are uncertain about the reliability of the source of a workbook and its macros, you can work with the macros disabled, which means that the code is not executable.

An event-driven program includes procedures that are executed when specific actions are taken by the user or other events occur.

-The ____ shown in the accompanying figure is used by all Office applications to enter, modify, and view Visual Basic for Applications code.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Another term that means a program or code.

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

A ____ is an attachment to a file or email message that vouches for its authenticity.

You can click the Stop/Start Macro button on the status bar to start or stop recording a macro.

Briefly discuss the four Macro setting options in the Macro Settings tab in the Trust Center dialog box.

Form controls and ActiveX controls look identical and function in the same way.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A potentially damaging computer program.

A(n) ____________________ is a digital signature that is displayed when you email a document from Excel.

Excel has a command or button for every possible worksheet task.

If you are uncertain about the reliability of the source of a workbook and its macros, you can work with the macros disabled, which means that the code is not executable.

An event-driven program includes procedures that are executed when specific actions are taken by the user or other events occur.

-The ____ shown in the accompanying figure is used by all Office applications to enter, modify, and view Visual Basic for Applications code.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Another term that means a program or code.

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