Question 1

Match between columns
                        Premises: Background
Template gallery
Theme
Template
Cell style

Accepted Answer

The Answer of Provides the ability to search and download is...

Question 2

Macros can be edited in the ________.

Accepted Answer

The answer of Macros can be edited in the ________....

Question 3

The VBA editor can be access using the keystroke combination ________.

Accepted Answer

The answer of The VBA editor can be access using...

Question 4

By default,the Developer tab is ________.

Accepted Answer

The answer of By default,the Developer tab is ________....

Question 5

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

Accepted Answer

The Answer of Provide the same formatting as commands in is...

Question 6

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

Accepted Answer

The Answer of When the worksheet is protected,these cells are is...

Question 7

By default,the macro recorder uses ________ references.

Accepted Answer

The answer of By default,the macro recorder uses ________ references....

Question 8

Recorded macros can be viewed in the ________.

Accepted Answer

The answer of Recorded macros can be viewed in the...

Question 9

Macro security can be edited in the ________.

Accepted Answer

The answer of Macro security can be edited in the...

Question 10

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

Accepted Answer

The Answer of Excel Macro-Enabled Workbook and Excel Binary Workbook is...

Question 11

Match between columns
                        Premises: Macro Recorder
Module
Visual Basic for Applications
Custom function
Sub procedure

Accepted Answer

The Answer of Visual Basic scripts that perform actions and is...

Question 12

Macros are stored in ________.

Accepted Answer

The answer of Macros are stored in ________....

Question 13

Match between columns
                        Premises: Privacy Options
Trusted Documents
Trusted Publishers
Add-Ins
File Block Settings

Accepted Answer

The Answer of Enables you to select which types of is...

Question 14

Match between columns
                        Premises: Visual Basic for Applications
Keyword
Comment
Module
Sub procedure

Accepted Answer

The Answer of A file in which macros are stored is...

Question 15

Match between columns
                        Premises: Run Time Error
Object
Sub procedure
Visual Basic for Applications
Module

Accepted Answer

The Answer of A variable that contains both data and is...

Question 16

By default,macros in Excel are ________.

Accepted Answer

The answer of By default,macros in Excel are ________....

Question 17

________ can be placed in VBA to provide information regarding a macro.

Accepted Answer

The answer of ________ can be placed in VBA to...

Question 18

Privacy options can be edited in the ________.

Accepted Answer

The answer of Privacy options can be edited in the...

Question 19

Match the following terms to the corresponding description:
I.Absolute reference
II.Form control button
III.Developer tab
IV.Trust Center
V.Personal macro workbook

Accepted Answer

The answer of Match the following terms to the corresponding...

Question 20

Match between columns
                        Premises: Object
Macro Recorder
Visual Basic Editor
Module
Personal Macro Workbook

Accepted Answer

The Answer of A variable that contains both data and is...

Quiz 43: Templates styles and Macros

Match the following terms with the corresponding description:

Macros can be edited in the ________.

The VBA editor can be access using the keystroke combination ________.

By default,the Developer tab is ________.

Match the following five predefined cell style categories with the corresponding definition:

Match the following terms with the corresponding descriptions:

By default,the macro recorder uses ________ references.

Recorded macros can be viewed in the ________.

Macro security can be edited in the ________.

Match the following terms with the corresponding descriptions:

Match the following terms with the corresponding descriptions:

Macros are stored in ________.

Match the following Trust Center options with the correct description:

Match the following terms to the corresponding description:

Match the following terms to the corresponding description:

By default,macros in Excel are ________.

________ can be placed in VBA to provide information regarding a macro.

Privacy options can be edited in the ________.

Match the following terms to the corresponding description: I.Absolute reference II.Form control button III.Developer tab IV.Trust Center V.Personal macro workbook

Match the following terms to the corresponding description: