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 without notification silently blocks all macros and provides no way for the user to enable them.

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

The macro recorder captures commands and keystrokes as you perform them, saving them as VBA code for later replay.

Question 3

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

Accepted Answer

If...Then...Else

Answer

The If...Then...Else construct evaluates a condition and executes different code blocks based on whether it is true or false.

Question 4

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

Accepted Answer

.ClearContents

Answer

The ClearContents method removes data from cells while preserving any formatting that has been applied.

Question 5

What is a 'Personal Macro Workbook' in Excel?

Accepted Answer

A hidden workbook that stores macros available in all Excel sessions

Answer

The Personal Macro Workbook (PERSONAL.XLSB) is a hidden file that opens automatically with Excel, making its macros available in all workbooks.

MCAS - Microsoft Certified Application Specialist Practice Test