Question 1

Keywords are words or symbols that are reserved for specific actions in VBA.

Accepted Answer

Keywords are reserved words in VBA that have specific actions and cannot be used as variable names or user-defined names. Examples of keywords in VBA include "if", "else", "for", and "sub".

Question 2

Trusted locations are websites where you download templates.

Accepted Answer

Trusted locations in computer security typically refer to directories or paths designated as safe by the user or administrator, where files can be opened without being checked by security measures like antivirus or firewall settings, not websites for downloading templates.

Question 3

You can pause the Macro Recorder in the middle of the recording process to edit mistakes.

Accepted Answer

The Macro Recorder in applications like Microsoft Excel does not have a pause feature; you must stop the recording to make edits and then start a new recording session.

Question 4

Excel has no method of stopping macro viruses.

Accepted Answer

Excel has built-in security measures and settings that can prevent macro viruses. For example, by default, Excel prompts the user to enable or disable macros when a file containing macros is opened, and macros can be digitally signed to verify their source. Additionally, antivirus software can detect and remove macro viruses. However, users must still exercise caution when downloading and opening files from untrusted sources.

Question 5

Images or other objects can serve as buttons to run macros.

Accepted Answer

Yes, images or other objects can be assigned as buttons to run macros in various programs such as Microsoft Excel or PowerPoint. When the button is clicked, the assigned macro will be executed.

Question 6

Form Controls are on the Developer tab.

Accepted Answer

Form Controls can be found on the Developer tab in most versions of Microsoft Excel.

Question 7

The Macro Recorder uses absolute references by default.

Accepted Answer

The Macro Recorder records actions using absolute references by default, which means that it records exact cell or range references. However, it is possible to change the reference type to relative if needed.

Question 8

Custom Functions are recorded in the macro recorder.

Accepted Answer

Custom functions cannot be recorded in the macro recorder. They must be written in VBA code.

Question 9

PDF file format is XML Paper Specifications.

Accepted Answer

PDF file format stands for Portable Document Format, which is not XML Paper Specifications (XPS). XPS is an alternative format created by Microsoft.

Question 10

In VBA,everything between and including the two following lines would be the CleanData sub procedure.
Sub CleanData()
End Sub

Accepted Answer

This is because the Sub keyword followed by a name and the End Sub statement defines and encloses a sub procedure in VBA.

Question 11

Match between columns
                        Premises: Sub Procedure
Object
Comment
Keyword
Module

Accepted Answer

The Answer of Starts with an apostrophe and green font.Used is...

Question 12

Match between columns
                        Premises: Absolute Reference
Personal Macro Workbook
VBA Editor
Macro
Macro Recorder

Accepted Answer

The Answer of Automation for a series of repetitive tasks is...

Question 13

Match between columns
                        Premises: ..xltm
.xlsm
.xlsx
.xls
.xltx

Accepted Answer

The Answer of Excel 97-2003 workbook and Excel workbook and is...

Question 14

Match between columns
                        Premises: Unprotected worksheet
Protected worksheet
Unlocked Cell
Password
Locked Cell

Accepted Answer

The Answer of Up to 255 characters to unlock a is...

Question 15

Match between columns
                        Premises: Number Format
Good,Bad,and Neutral
Data and Model
Themed Cell Styles
Titles and Headings

Accepted Answer

The Answer of Emphasizes bad,good,or neutral results and Provides visual is...

Question 16

Match between columns
                        Premises: Template
Template Gallery
Theme
Theme Gallery
Cell Style

Accepted Answer

The Answer of A partially completed document to use as is...

Question 17

Match between columns
                        Premises: Theme
VBA
Custom Function
Template
Macro

Accepted Answer

The Answer of A programming language for Office and Collection is...

Quiz 12: Templates, styles, and Macros

Keywords are words or symbols that are reserved for specific actions in VBA.

Trusted locations are websites where you download templates.

You can pause the Macro Recorder in the middle of the recording process to edit mistakes.

Excel has no method of stopping macro viruses.

Images or other objects can serve as buttons to run macros.

Form Controls are on the Developer tab.

The Macro Recorder uses absolute references by default.

Custom Functions are recorded in the macro recorder.

PDF file format is XML Paper Specifications.

In VBA,everything between and including the two following lines would be the CleanData sub procedure. Sub CleanData() End Sub

Match each of the following terms to its best description:

Match each of the following concepts to its best description:

Correctly match the following File extensions to its best description of file type:

Match each of the following terms to its best description:

Match each of the following cell styles categories with its purpose:

Match each of the following terms with its best description:

Match each of the following concepts to its best description: