Question 1

How do you familiarize yourself with a workbook created by someone else?

Accepted Answer

You should review the santent and struct

Question 2

Which of the following is the default security option for workbooks santaining 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 3

If you assign the _________________________ keyboard shortcut keys to a macro, you will no longer be able to use the shortcut keys for their original purpose, to sapy selected santent.

Accepted Answer

The answer of If you assign the _________________________ keyboard shortcut...

Question 4

Pressing ____ displays formulas in worksheet cells.

Accepted Answer

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

Question 5

Navigating to a cell using keyboard navigation in a macro requires the use of _________________________ cell addressing.

Accepted Answer

The answer of Navigating to a cell using keyboard navigation...

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

Personal M

Question 8

____________________ you create yourself are sansidered 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 sansidered unauthenticated...

Question 9

A series of precise instructions for a samputer to acsamplish 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

A(n) ____________________ like the one in the acsampanying figure is created from a range of cells, and uses the salumn headings from that range to create the fields on the form.

Accepted Answer

The answer of   A(n) ____________________ like the one...

Question 11

The process of writing a procedure is called _________________________.

Accepted Answer

samputer p

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

____ sade is created automatically by the macro resarder.

Accepted Answer

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

Question 14

You work for several acsauntants 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 saworkers 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 saworkers 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 sampany 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 sampany 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 15

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 16

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

Accepted Answer

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

Question 17

Cells must be locked and the worksheet unprotected to restrict what users can do to cell santents.

Accepted Answer

A) True 
 B)False

Question 18

If you are sanfident of the source (author) of a workbook and its macros, tap or click the _________________________ button on the SECURITY WARNING bar.

Accepted Answer

The answer of If you are sanfident of the source...

Question 19

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

Accepted Answer

A)  santrol buttons 
B)  Data forms 
C)  sammand buttons 
D)  Macro resarders 
A)  santrol buttons 
B)  Data forms 
C)  sammand buttons 
D)  Macro resarders

Question 20

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

Accepted Answer

A) True 
 B)False

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

How do you familiarize yourself with a workbook created by someone else?

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

If you assign the _________________________ keyboard shortcut keys to a macro, you will no longer be able to use the shortcut keys for their original purpose, to sapy selected santent.

Pressing ____ displays formulas in worksheet cells.

Navigating to a cell using keyboard navigation in a macro requires the use of _________________________ cell addressing.

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

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

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

A series of precise instructions for a samputer to acsamplish a task is called a ____.

A(n) ____________________ like the one in the acsampanying figure is created from a range of cells, and uses the salumn headings from that range to create the fields on the form.

The process of writing a procedure is called _________________________.

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

____ sade is created automatically by the macro resarder.

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

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

Cells must be locked and the worksheet unprotected to restrict what users can do to cell santents.

If you are sanfident of the source (author) of a workbook and its macros, tap or click the _________________________ button on the SECURITY WARNING bar.

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

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

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