Question 1

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.
A) Installation Defaults
B) Restore Settings
C) Factory preset
D) Excel Options

Accepted Answer

The Customize Quick Access Toolbar options are located in the Excel Options dialog box. Therefore, the correct choice is D.

Question 2

____ controls provide great flexibility in terms of their design.
A) Option Button
B) Form
C) Command Button
D) ActiveX

Accepted Answer

ActiveX controls are versatile and can be customized extensively. They can be used to create tailored controls with specific functionality and appearance.

Question 3

You can delete a control by pressing and holding or right-clicking the control and selecting ____ on the shortcut menu.
A) Delete
B) Remove
C) Cut
D) Edit

Accepted Answer

The answer of You can delete a control by pressing...

Question 4

Macros are known carriers of ____ because of the ease with which a person can add programming code to them.
A) viruses
B) beacons
C) errors
D) agents

Accepted Answer

Macros are often used to spread viruses because they can contain programming code that can execute on a user's computer when the macro is opened. This is why many users are hesitant to enable macros in documents received from unknown or untrusted sources.

Question 5

Which of the following is the default security option for workbooks containing macros?
A) Disable all macros with notification
B) Enable all macros
C) Disable all macros except digitally signed macros
D) Disable all macros without notification

Accepted Answer

The default security setting for workbooks containing macros in most versions of Excel is "Disable all macros with notification," which means macros are disabled, but the user is notified and can choose to enable them.

Question 6

-The ____ shown in the accompanying figure is used by all Office applications to enter, modify, and view Visual Basic for Applications code.
A) Visual Basic Recorder
B) Visual Basic Interpreter
C) Visual Basic Editor
D) none of the above

Accepted Answer

The Visual Basic Editor (VBE) is the tool used in Microsoft Office applications to write, edit, and view VBA code.

Question 7

Which of the following is the path to the 'Create from Selection' button used to assign names to cells and enter necessary references?
A)(DEVELOPER tab | Range Names group)
B)(DATA tab | Ranges group)
C)(FORMULAS tab | Defined Names group)
D)(VIEW tab | Set Names group)

Accepted Answer

The 'Create from Selection' button is located in the FORMULAS tab under the Defined Names group in Excel.

Question 8

Signed macros based on your own digital certificate are called ____.
A) commercially-signed projects
B) dynamically managed projects
C) self-signed projects
D) none of the above

Accepted Answer

Signed macros based on your own digital certificate are called self-signed projects.

Question 9

You can use the ____ form control to position a set of option buttons together.
A) Group Box
B) Spin Button
C) Label
D) Scroll Bar

Accepted Answer

The Group Box form control allows you to group a set of option buttons together, which makes it easier for users to understand which options belong together. The Spin Button, Label, and Scroll Bar controls are not relevant for this purpose.

Question 10

Each ActiveX control available in the Controls gallery has many ____.
A) properties
B) facets
C) names
D) none of the above

Accepted Answer

ActiveX controls have many properties, which allow customization and flexibility in their use. These properties can be accessed and modified in the Properties window.

Question 11

____ controls require no knowledge of VBA to be used.
A) Dynamic object
B) Form
C) ActiveX
D) Worksheet management

Accepted Answer

Forms in Excel allow users to easily create input forms or user interfaces without needing to know VBA. They can be created and customized using the built-in form controls available on the Developer tab. Dynamic objects, ActiveX controls, and worksheet management all typically require some knowledge of VBA to be used effectively.

Question 12

You can use the options in the ____ dialog box to apply colors and patterns to make controls stand out more.
A) Format Borders and Fill
B) Format Control
C) Format Object
D) Format Options

Accepted Answer

The answer of You can use the options in the...

Question 13

In which of the following modes can you set the properties that determine a control's appearance and behavior?
A) Run
B) Design
C) Execute
D) Modify

Accepted Answer

In the Design mode, you can set the properties of a control and customize it as per your requirements. In the Run mode, you can only see how the control works and interacts with the user. The Execute mode and Modify mode are not standard modes in software development and are not relevant in this context.

Question 14

You can open the Properties window by tapping or clicking the Control Properties button ____ in Design mode.
A)(DEVELOPER tab | Add-Ins group)
B)(DEVELOPER tab | Controls group)
C)(DEVELOPER tab | Code group)
D)(DEVELOPER tab | XML group)

Accepted Answer

The question specifically mentions Design mode, which is only available within the DEVELOPER tab of the Ribbon. The Properties window is located within the Controls group of the DEVELOPER tab. Therefore, the correct answer is B.

Question 15

You should test code before you enter it by stepping through the instructions one at a time in a process called ____ checking.
A) procedure
B) process
C) desk
D) instruction

Accepted Answer

Desk checking is the process of manually stepping through code instructions to verify correctness before actual execution.

Question 16

Comments can be placed at any of the following positions EXCEPT ____.
A) in between lines of code
B) before the Supplement statement
C) at the end of a line of code
D) before the Sub statement

Accepted Answer

Comments can be placed in between lines of code, at the end of a line of code, and before the Sub statement. However, they cannot be placed before the Supplement statement as there is no such statement in the context of programming.

Question 17

A ____ is an attachment to a file or email message that vouches for its authenticity.
A) digital comment
B) digital certificate
C) certification authority
D) digital signature

Accepted Answer

A digital certificate is a secure way to verify the authenticity of a file or email message. It is issued by a certification authority and contains information about the sender of the message, including a digital signature. This allows the recipient to verify that the message has not been tampered with and comes from a trusted source. Digital comments are not related to authenticity verification, and a certification authority is responsible for issuing digital certificates.

Question 18

____ code is created automatically by the macro recorder.
A) ABC
B) VBA
C) XTM
D) RCC

Accepted Answer

VBA (Visual Basic for Applications) code is created automatically by the macro recorder.

Question 19

You can open the VBE Immediate window to debug and execute statements during design by pressing ____.
A) CTRL+I
B) CTRL+G
C) CTRL+F
D) CTRL+J

Accepted Answer

Pressing CTRL+G will open the VBE Immediate window in Excel.

Question 20

It is good practice to place comments containing overall documentation and information before the ____ statement.
A) Sub
B) Supplement
C) Public
D) Rem

Accepted Answer

The answer of It is good practice to place comments...

Quiz 11: Using Macros and Visual Basic for Applications Vba With Excel

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.

____ controls provide great flexibility in terms of their design.

You can delete a control by pressing and holding or right-clicking the control and selecting ____ on the shortcut menu.

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

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

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

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

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

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

Each ActiveX control available in the Controls gallery has many ____.

____ controls require no knowledge of VBA to be used.

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

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

You can open the Properties window by tapping or clicking the Control Properties button ____ in Design mode.

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

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

A ____ is an attachment to a file or email message that vouches for its authenticity.

____ code is created automatically by the macro recorder.

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

It is good practice to place comments containing overall documentation and information before the ____ statement.