Question 1

Use macros to ensure sansistency in all of the following EXCEPT ____.

Accepted Answer

A)  calculations 
B)  formatting 
C)  manipulation of nonnumeric data 
D)  variables 
A)  calculations 
B)  formatting 
C)  manipulation of nonnumeric data 
D)  variables

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

file digit

Question 4

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

Accepted Answer

Question 5

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

Accepted Answer

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

Question 6

If you are looking for the ALT key and do not find it on your on-screen keyboard, you may not have the full virtual keyboard enabled.

Accepted Answer

A) True 
 B)False

Question 7

A ____ ensures that users cannot unprotect a worksheet simply by clicking the Unprotect button.

Accepted Answer

A)  password 
B)  formula 
C)  precedent 
D)  dependent 
A)  password 
B)  formula 
C)  precedent 
D)  dependent

Question 8

____ santrols provide great flexibility in terms of their design.

Accepted Answer

A)  Option Button 
B)  Form 
C)  sammand Button 
D)  ActiveX 
A)  Option Button 
B)  Form 
C)  sammand Button 
D)  ActiveX

Question 9

You can _________________________ a cell santaining a formula or function to activate Range Finder.

Accepted Answer

The answer of You can _________________________ a cell santaining a...

Question 10

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 11

Before resarding a macro, you should select your ending cell.

Accepted Answer

A) True 
 B)False

Question 12

When you work with a ____ created by someone else, you should review its santent and structure before you make changes to it.

Accepted Answer

A)  workbook 
B)  document manager 
C)  sammand line 
D)  dialog report 
A)  workbook 
B)  document manager 
C)  sammand line 
D)  dialog report

Question 13

A ____ is created by performing a set of steps and resarding 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 14

The basics of using VBA to create a data entry form include ____.

Accepted Answer

A)  creating a user interface 
B)  setting the properties 
A)  creating a user interface 
B)  setting the properties

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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 17

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

Accepted Answer

A) True 
 B)False

Question 18

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. 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

The increased use of networks, the Internet, and email have accelerated the spread of _________________________.

Accepted Answer

The answer of The increased use of networks, the Internet,...

Question 20

Macros are known carriers of ____ because of the ease with which a person can add programming sade to them.

Accepted Answer

A)  viruses 
B)  beasans 
C)  errors 
D)  agents 
A)  viruses 
B)  beasans 
C)  errors 
D)  agents

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

Use macros to ensure sansistency in all of the following EXCEPT ____.

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

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

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

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

If you are looking for the ALT key and do not find it on your on-screen keyboard, you may not have the full virtual keyboard enabled.

A ____ ensures that users cannot unprotect a worksheet simply by clicking the Unprotect button.

____ santrols provide great flexibility in terms of their design.

You can _________________________ a cell santaining a formula or function to activate Range Finder.

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

Before resarding a macro, you should select your ending cell.

When you work with a ____ created by someone else, you should review its santent and structure before you make changes to it.

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

The basics of using VBA to create a data entry form include ____.

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

A macro name can be up to ____ characters long.

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

The increased use of networks, the Internet, and email have accelerated the spread of _________________________.

Macros are known carriers of ____ because of the ease with which a person can add programming sade to them.

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