Question 1

An Excel ____ is a procedure samposed of VBA sade.

Accepted Answer

A)  micro 
B)  list 
C)  macro 
D)  table 
A)  micro 
B)  list 
C)  macro 
D)  table

Question 2

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

Accepted Answer

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

Question 3

It is good practice to place samments santaining 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 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

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

Question 6

You should select the ending cell before turning on the macro resarder.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

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

Question 8

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 9

____ santrols require no knowledge of VBA to be used.

Accepted Answer

A)  Dynamic object 
B)  Form 
C)  ActiveX 
D)  Worksheet management 
A)  Dynamic object 
B)  Form 
C)  ActiveX 
D)  Worksheet management

Question 10

Which of the following sammands 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 11

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

Accepted Answer

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

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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 14

Every Excel sammand and ribbon button has a sarresponding Answer Report that the samputer executes.

Accepted Answer

A) True 
 B)False

Question 15

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 16

You should test sade 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 17

When a user interacts with a santrol, the Visual Basic sade that is associated with that action is executed.

Accepted Answer

A) True 
 B)False

Question 18

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 resammendations 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 sammercial 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 sammercial 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 19

Briefly explain the rules for assigning passwords in Excel.

Accepted Answer

Passwords in Excel can santain, in any s

Question 20

Passwords in Excel can santain ____.

Accepted Answer

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

Exam 21: Using Macros, Controls, and Visual Basic for Applications Vba With Excel Question

An Excel ____ is a procedure samposed of VBA sade.

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

It is good practice to place samments santaining overall documentation and information before the ____ statement.

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

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

You should select the ending cell before turning on the macro resarder.

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

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

____ santrols require no knowledge of VBA to be used.

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

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

A macro's steps and their order should be determined and rehearsed after creating 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.

Every Excel sammand and ribbon button has a sarresponding Answer Report that the samputer executes.

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

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

When a user interacts with a santrol, the Visual Basic sade that is associated with that action is executed.

Briefly explain the rules for assigning passwords in Excel.

Passwords in Excel can santain ____.

Databases and Database Objects

Querying a Database

Maintaining a Database

Creating Reports and Forms Question

Multiple-Table Forms Question MC

Advanced Report Techniques Question

Advanced Form Techniques

Macros, Navigation Forms, and Control Layouts

Administering a Database System

Using Sql Question

Database Design

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting Question

Working With Large Worksheets, Charting, and What-If Analysis Question

Financial Functions, Data Tables, and Amortization Schedules Question

Working With Multiple Worksheets and Workbooks Question

Creating, Sorting, and Querying a Table Question

Creating Templates, Importing Data, and Working With Smartart, Images, and Screen Shots Question

Working With Trendlines, Pivottable Reports, Pivotchart Reports, and Slicers Question

Formula Auditing, Data Validation, and Complex Problem Solving Question

Collaboration Features for Workbooks Question

Appendix: Introduction to Technology

Appendix: Office 365 Essentials

Managing Email Messages With Outlook

Managing Calendars With Outlook

Managing Contacts and Personal Contact Information With Outlook

Creating and Managing Tasks With Outlook

Customizing Outlook

Creating and Editing a Presentation With Pictures

Enhancing a Presentation With Pictures, Shapes, and Wordart

Reusing a Presentation and Adding Media and Animation

Creating and Formatting Information Graphics

Collaborating on and Delivering a Presentation

Navigating Presentations Using Hyperlinks and Action Buttons

Creating a Self-Running Presentation Containing Animation

Customizing a Template and Handouts Using Masters

Modifying a Presentation Using Graphical Elements

Developing a Presentation With Content From Outside Sources

Organizing Slides and Creating a Photo Album

Creating, Formatting, and Editing in Webct

Creating a Research Paper With References and Sources

Creating a Business Letter With a Letterhead and Table

Creating a Document With a Title Page, Lists, Tables, and a Watermark

Using a Template to Create a Resume and Sharing a Finished Document

Generating Form Letters, Mailing Labels, and a Directory

Creating a Newsletter With a Pull-Quote and Graphics

Using Document Collaboration, Integration, and Charting Tools

Creating a Reference Document With a Table of Contents and an Index

Creating a Template for an Online Form

Enhancing an Online Form and Using Macros

Filters