MCAS Macros & Automation 3

Question 1

Which security level in Office Trust Center completely blocks all macros with no user override?

Accepted Answer

Disable all macros without notification

Answer

Disable all macros with notification

Answer

Enable all macros

Answer

Disable all macros except digitally signed macros

Question 2

What does the macro recorder in Microsoft Word capture when creating a macro?

Accepted Answer

A series of commands and keystrokes that can be replayed

Answer

Only keyboard shortcuts

Answer

Screenshots of the document

Answer

Font and paragraph settings only

Question 3

Which VBA construct is used to make decisions in a macro based on a condition?

Accepted Answer

If...Then...Else

Answer

Select Loop

Answer

For...Each

Answer

Do While

Question 4

In Excel VBA, which method clears the contents of a cell range without removing formatting?

Accepted Answer

.ClearContents

Answer

.Delete

Answer

.Clear

Answer

.ClearFormats

Question 5

What is a 'Personal Macro Workbook' in Excel?

Accepted Answer

A hidden workbook that stores macros available in all Excel sessions

Answer

A workbook shared with other users on a network

Answer

A workbook protected with a password

Answer

A template file for new workbooks

Question 6

Which VBA event procedure runs automatically when an Excel workbook is opened?

Accepted Answer

Workbook_Open

Answer

Workbook_Start

Answer

Workbook_Load

Answer

Workbook_Activate

Question 7

To protect a VBA project from being viewed or edited, which option should you use?

Accepted Answer

Use the 'Lock project for viewing' option in VBA Project Properties

Answer

Save the file as read-only

Answer

Encrypt the workbook with a password

Answer

Set macro security to Disable all macros