Question 1

Once you start recording a macro, any task you perform in Excel will be part of the macro.

Accepted Answer

A) True 
 B)False

Question 2

If you lose an Excel password, you can request the password from Microsoft in order to gain access to the password-protected worksheet.

Accepted Answer

A) True 
 B)False

Question 3

In which of the following modes can you set the properties that determine a control's appearance and behavior?

Accepted Answer

A)  Run 
B)  Design 
C)  Execute 
D)  Modify 
A)  Run 
B)  Design 
C)  Execute 
D)  Modify

Question 4

Macros provide you with an opportunity to make certain tasks much more efficient and accurate.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following functions can you use to determine the position of the space that separates a first and last name?

Accepted Answer

A)  SEARCH 
B)  LEN 
C)  LEFT 
D)  RIGHT 
A)  SEARCH 
B)  LEN 
C)  LEFT 
D)  RIGHT

Question 6

Passwords in Excel can contain ____.

Accepted Answer

A)  letters 
B)  numbers 
C)  spaces 
D)  up to 30 characters 
A)  letters 
B)  numbers 
C)  spaces 
D)  up to 30 characters

Question 7

You can reset the Quick Access Toolbar to its installation default by tapping or clicking the Reset button in the Customize Quick Access Toolbar options in the ____ dialog box.

Accepted Answer

A)  Installation Defaults 
B)  Restore Settings 
C)  Factory preset 
D)  Excel Options 
A)  Installation Defaults 
B)  Restore Settings 
C)  Factory preset 
D)  Excel Options

Question 8

Briefly explain the rules for assigning passwords in Excel.

Accepted Answer

Passwords in Excel can contain, in any c

Question 9

You cannot assign an Excel macro directly to a form control.

Accepted Answer

A) True 
 B)False

Question 10

A macro name can be up to ____ characters long.

Accepted Answer

A)  8 
B)  32 
C)  127 
D)  255 
A)  8 
B)  32 
C)  127 
D)  255

Question 11

A computer ____ is a potentially damaging computer program designed to affect your computer negatively by altering the way it works.

Accepted Answer

A)  blister 
B)  patch 
C)  virus 
D)  fever 
A)  blister 
B)  patch 
C)  virus 
D)  fever

Question 12

You can add the DEVELOPER tab to the Ribbon with options in the ____ dialog box.

Accepted Answer

A) Customize Ribbon 
B) Excel Options 
C) Trust Center 
D) none of the above 
A) Customize Ribbon 
B) Excel Options 
C) Trust Center 
D) none of the above

Question 13

Case 10-2
Len, your supervisor, asks you to research security issues surrounding distributing Excel workbooks internally to employees and externally to clients. He wants to discuss your research and recommendations next Tuesday.
-To begin Tuesday's meeting, Len asks you to explain the difference between a digital signature and a digital certificate. You explain that ____.

Accepted Answer

A)  a digital certificate is an electronic secure stamp of authentication; a digital signature is an attachment to a file or e-mail message that vouches for its authenticity 
B)  you are not sure; perhaps someone from the IT department can answer that question 
C)  a digital signature is an electronic secure stamp of authentication; a digital certificate is an attachment to a file or e-mail message that vouches for its authenticity 
D)  digital signatures and digital certificates play no role in security issues surrounding the internal or external exchange of Excel workbooks 
A)  a digital certificate is an electronic secure stamp of authentication; a digital signature is an attachment to a file or e-mail message that vouches for its authenticity 
B)  you are not sure; perhaps someone from the IT department can answer that question 
C)  a digital signature is an electronic secure stamp of authentication; a digital certificate is an attachment to a file or e-mail message that vouches for its authenticity 
D)  digital signatures and digital certificates play no role in security issues surrounding the internal or external exchange of Excel workbooks

Question 14

Case 10-2
Len, your supervisor, asks you to research security issues surrounding distributing Excel workbooks internally to employees and externally to clients. He wants to discuss your research and recommendations next Tuesday.
-Next, Len asks you to explain the role a certificate authority plays in the process of authenticating Excel workbooks. You tell Len that a certificate authority ____.

Accepted Answer

A)  is a commercial entity that issues digital certificates 
B)  authenticates self-signing projects 
C)  distributes Excel workbooks that have been authenticated 
D)  plays no role in authenticating Excel workbooks 
A)  is a commercial entity that issues digital certificates 
B)  authenticates self-signing projects 
C)  distributes Excel workbooks that have been authenticated 
D)  plays no role in authenticating Excel workbooks

Question 15

You delete a macro by tapping or clicking the _________________________ of the macro in the Macro dialog box, and then tapping or clicking the Delete button.

Accepted Answer

The answer of You delete a macro by tapping or...

Question 16

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Ensures that users cannot unprotect a worksheet simply by clicking the Unprotect Sheet button.

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 17

A ____ is created by performing a set of steps and recording the steps as they are performed.

Accepted Answer

A)  table 
B)  macro 
C)  report 
D)  calculation 
A)  table 
B)  macro 
C)  report 
D)  calculation

Question 18

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.
-As the 'brainstorming session' begins, Lucy asks how best to get started on the form. You suggest that the team first familiarize itself with the workbook, since it was created by another team. Which of the following is NOT a suggestion you make to this end?

Accepted Answer

A)  Enter sample data and verify the results. 
B)  Use Cell Reference Manager to show which cells are referenced in formulas and functions. 
C)  Check which cells are locked and which cells are unlocked. 
D)  Press CTRL+ACCENT MARK to display any formulas. 
A)  Enter sample data and verify the results. 
B)  Use Cell Reference Manager to show which cells are referenced in formulas and functions. 
C)  Check which cells are locked and which cells are unlocked. 
D)  Press CTRL+ACCENT MARK to display any formulas.

Question 19

Which of the following is the path to the 'Create from Selection' button used to assign names to cells and enter necessary references?

Accepted Answer

Question 20

You can set a keyboard shortcut key combination for executing a macro with an option in the Record Macro dialog box.

Accepted Answer

A) True 
 B)False

Once you start recording a macro, any task you perform in Excel will be part of the macro.

If you lose an Excel password, you can request the password from Microsoft in order to gain access to the password-protected worksheet.

In which of the following modes can you set the properties that determine a control's appearance and behavior?

Macros provide you with an opportunity to make certain tasks much more efficient and accurate.

Which of the following functions can you use to determine the position of the space that separates a first and last name?

Passwords in Excel can contain ____.

You can reset the Quick Access Toolbar to its installation default by tapping or clicking the Reset button in the Customize Quick Access Toolbar options in the ____ dialog box.

Briefly explain the rules for assigning passwords in Excel.

You cannot assign an Excel macro directly to a form control.

A macro name can be up to ____ characters long.

A computer ____ is a potentially damaging computer program designed to affect your computer negatively by altering the way it works.

You can add the DEVELOPER tab to the Ribbon with options in the ____ dialog box.

You delete a macro by tapping or clicking the _________________________ of the macro in the Macro dialog box, and then tapping or clicking the Delete button.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Ensures that users cannot unprotect a worksheet simply by clicking the Unprotect Sheet button.

A ____ is created by performing a set of steps and recording the steps as they are performed.

Which of the following is the path to the 'Create from Selection' button used to assign names to cells and enter necessary references?

You can set a keyboard shortcut key combination for executing a macro with an option in the Record Macro dialog box.

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

Once you start recording a macro, any task you perform in Excel will be part of the macro.

If you lose an Excel password, you can request the password from Microsoft in order to gain access to the password-protected worksheet.

In which of the following modes can you set the properties that determine a control's appearance and behavior?

Macros provide you with an opportunity to make certain tasks much more efficient and accurate.

Which of the following functions can you use to determine the position of the space that separates a first and last name?

Passwords in Excel can contain ____.

You can reset the Quick Access Toolbar to its installation default by tapping or clicking the Reset button in the Customize Quick Access Toolbar options in the ____ dialog box.

Briefly explain the rules for assigning passwords in Excel.

You cannot assign an Excel macro directly to a form control.

A macro name can be up to ____ characters long.

A computer ____ is a potentially damaging computer program designed to affect your computer negatively by altering the way it works.

You can add the DEVELOPER tab to the Ribbon with options in the ____ dialog box.

You delete a macro by tapping or clicking the _________________________ of the macro in the Macro dialog box, and then tapping or clicking the Delete button.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Ensures that users cannot unprotect a worksheet simply by clicking the Unprotect Sheet button.

A ____ is created by performing a set of steps and recording the steps as they are performed.

Which of the following is the path to the 'Create from Selection' button used to assign names to cells and enter necessary references?

You can set a keyboard shortcut key combination for executing a macro with an option in the Record Macro dialog box.

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