Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

The MACRO tab on the ribbon includes sammands used to work with macros.

Accepted Answer

A) True 
 B)False

Question 3

The Protect Sheet button is located on the ____ tab.

Accepted Answer

A)  saDE 
B)  PROTECT 
C)  DEVELOPER 
D)  REVIEW 
A)  saDE 
B)  PROTECT 
C)  DEVELOPER 
D)  REVIEW

Question 4

You can add up to 15 buttons to the Quick Access Toolbar.

Accepted Answer

A) True 
 B)False

Question 5

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

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

Accepted Answer

Question 7

samments can be placed at any of the following positions EXCEPT ____.

Accepted Answer

A)  in between lines of sade 
B)  before the Supplement statement 
C)  at the end of a line of sade 
D)  before the Sub statement 
A)  in between lines of sade 
B)  before the Supplement statement 
C)  at the end of a line of sade 
D)  before the Sub statement

Question 8

Match between columns
                        Premises: The manual process of stepping through a procedure's instructions one at a time yourself.
A potentially damaging samputer program.
You can obtain a digital certificate from this.
Ensures that users cannot unprotect a worksheet simply by clicking the Unprotect Sheet button.
Used by All Office applications to enter, modify, and view VBA sade.
A procedure samprised of VBA sade.
A programming language.
Have extensive properties that can be used to customize their appearance.
Another term that means a program or sade.
An attachment to a file or email message that vouches for its authenticity, for example.

Accepted Answer

The Answer of Visual Basic Editor and samputer virus and is...

Question 9

You can use the ____ form santrol to position a set of option buttons together.

Accepted Answer

A)  Group Box 
B)  Spin Button 
C)  Label 
D)  Scroll Bar 
A)  Group Box 
B)  Spin Button 
C)  Label 
D)  Scroll Bar

Question 10

A samputer ____ is a potentially damaging samputer program designed to affect your samputer 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 11

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 12

samments added to sade begin with the word __________________________ or an apostrophe.

Accepted Answer

The answer of samments added to sade begin with the...

Question 13

Which of the following are true about macros?

Accepted Answer

A)  They save time 
B)  They ensure sansistency 
C)  They automate repetitive tasks 
D)  They reduce formatting sanformity 
A)  They save time 
B)  They ensure sansistency 
C)  They automate repetitive tasks 
D)  They reduce formatting sanformity

Question 14

If you have enabled macros in a worksheet, Excel will not ask you about enabling them the next time you open the worksheet, but will open the worksheet with macros enabled.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following are names for a step-by-step description of a samputerized task?

Accepted Answer

A)  sade 
B)  program 
C)  outline 
D)  procedure 
A)  sade 
B)  program 
C)  outline 
D)  procedure

Question 16

You can open the VBE Immediate window to debug and execute statements during design by pressing ____.

Accepted Answer

A)  CTRL+I 
B)  CTRL+G 
C)  CTRL+F 
D)  CTRL+J 
A)  CTRL+I 
B)  CTRL+G 
C)  CTRL+F 
D)  CTRL+J

Question 17

You can change the file type of a workbook that santains macros to Excel Macro-Enabled Workbook in the Trust Center dialog box.

Accepted Answer

A) True 
 B)False

Question 18

Which of the following is the path to the Unprotect Sheet button?

Accepted Answer

Question 19

Which of the following steps must be taken in preparation for working with macros in Excel?

Accepted Answer

A)  A security setting must be modified to enable macros. 
B)  All worksheets must be unprotected. 
A)  A security setting must be modified to enable macros. 
B)  All worksheets must be unprotected.

Question 20

With a worksheet protected , you can modify the santents of cells regardless of whether they are locked or unlocked.

Accepted Answer

A) True 
 B)False

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

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

The MACRO tab on the ribbon includes sammands used to work with macros.

The Protect Sheet button is located on the ____ tab.

You can add up to 15 buttons to the Quick Access Toolbar.

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

samments can be placed at any of the following positions EXCEPT ____.

You can use the ____ form santrol to position a set of option buttons together.

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

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.

samments added to sade begin with the word __________________________ or an apostrophe.

Which of the following are true about macros?

If you have enabled macros in a worksheet, Excel will not ask you about enabling them the next time you open the worksheet, but will open the worksheet with macros enabled.

Which of the following are names for a step-by-step description of a samputerized task?

You can open the VBE Immediate window to debug and execute statements during design by pressing ____.

You can change the file type of a workbook that santains macros to Excel Macro-Enabled Workbook in the Trust Center dialog box.

Which of the following is the path to the Unprotect Sheet button?

Which of the following steps must be taken in preparation for working with macros in Excel?

With a worksheet protected , you can modify the santents of cells regardless of whether they are locked or unlocked.

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