MCAS Macros & Automation 2

Question 1

Which object in VBA refers to the currently active workbook in Excel?

Accepted Answer

ActiveWorkbook

Answer

ActiveWorkbook refers to the workbook that currently has focus, while ThisWorkbook refers to the workbook containing the code.

Question 2

What VBA statement is used to display a message box to the user?

Accepted Answer

MsgBox

Answer

MsgBox is the VBA function used to display a pop-up message box to the user.

Question 3

In a VBA macro, which loop structure repeats a block of code a specific number of times?

Accepted Answer

For...Next

Answer

The For...Next loop iterates a set number of times using a counter variable.

Question 4

How can a macro be assigned to a button in an Excel worksheet?

Accepted Answer

Right-click the button and select 'Assign Macro'

Answer

Right-clicking a form control button and selecting 'Assign Macro' links a recorded or written macro to that button.

Question 5

Which Excel Quick Access Toolbar customization allows you to run a macro with one click?

Accepted Answer

Adding a macro command to the QAT via File > Options > Quick Access Toolbar

Answer

You can add a macro as a custom button on the Quick Access Toolbar through File > Options > Quick Access Toolbar.

MCAS - Microsoft Certified Application Specialist Practice Test