Question 1

Comments cannot be viewed in the VBA editor.

Accepted Answer

A) True 
 B)False

Question 2

By default,the Developer tab is ________.

Accepted Answer

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

Question 3

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 4

Once created,macro buttons cannot be deleted.

Accepted Answer

A) True 
 B)False

Question 5

Recorded macros can be viewed in the ________.

Accepted Answer

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

Question 6

Which of the following is not controlled with cell style formats?

Accepted Answer

A) Font attributes 
B) Print settings 
C) Cell-protection settings 
D) Border and fill styles

Question 7

A run time error will occur if a sub procedure is run on a protected workbook.

Accepted Answer

A) True 
 B)False

Question 8

Which of the following is not a tool to help provided a unified look and feel within a workbook?

Accepted Answer

A) Themes 
B) Custom functions 
C) Backgrounds 
D) Styles

Question 9

Form controls are located on the Developer tab.

Accepted Answer

A) True 
 B)False

Question 10

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 11

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 12

What is the password character limit in Excel?

Accepted Answer

A) 325 
B) 255 
C) 355 
D) 100

Question 13

Where is the Insert Background feature located?

Accepted Answer

A) Backstage 
B) Page Layout tab 
C) Formulas tab 
D) Insert tab

Question 14

Comments in VBA appear in what color?

Accepted Answer

A) Red 
B) Green 
C) Blue 
D) Black

Question 15

Which of the following is the proper beginning for a sub procedure named "Test"?

Accepted Answer

A) Sub () 
B) Sub (Test) 
C) (Test) 
D) Sub Test()

Question 16

The Themes gallery is located on the ________ tab.

Accepted Answer

The answer of The Themes gallery is located on the...

Question 17

Where is the Themes gallery located?

Accepted Answer

A) Backstage 
B) Data tab 
C) Page Layout tab 
D) Insert tab

Question 18

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 19

Macros are stored in modules.

Accepted Answer

A) True 
 B)False

Question 20

By default,macros in Excel are ________.

Accepted Answer

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

Exam 43: Templates styles and Macros

Comments cannot be viewed in the VBA editor.

By default,the Developer tab is ________.

Match the following terms with the corresponding description:

Once created,macro buttons cannot be deleted.

Recorded macros can be viewed in the ________.

Which of the following is not controlled with cell style formats?

A run time error will occur if a sub procedure is run on a protected workbook.

Which of the following is not a tool to help provided a unified look and feel within a workbook?

Form controls are located on the Developer tab.

Match the following terms with the corresponding descriptions:

Match the following terms to the corresponding description:

What is the password character limit in Excel?

Where is the Insert Background feature located?

Comments in VBA appear in what color?

Which of the following is the proper beginning for a sub procedure named "Test"?

The Themes gallery is located on the ________ tab.

Where is the Themes gallery located?

Match the following terms to the corresponding description:

Macros are stored in modules.

By default,macros in Excel are ________.