MCAS Macros & Automation 2

Question 1

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

Accepted Answer

ActiveWorkbook

Answer

ThisWorkbook

Answer

CurrentWorkbook

Answer

OpenWorkbook

Question 2

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

Accepted Answer

MsgBox

Answer

InputBox

Answer

Alert

Answer

ShowMessage

Question 3

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

Accepted Answer

For...Next

Answer

Do While...Loop

Answer

Do Until...Loop

Answer

While...Wend

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

Double-click the button in the ribbon

Answer

Use File > Options > Macros

Answer

Drag the macro name onto the 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

Dragging the macro from the Formulas tab

Answer

Pinning the macro in the Review tab

Answer

Using Format Cells to link the macro

Question 6

What is the purpose of the 'Option Explicit' statement at the top of a VBA module?

Accepted Answer

It requires all variables to be declared before use

Answer

It enables macro recording

Answer

It sets the macro security level

Answer

It exports the module to a file

Question 7

In VBA, which keyword is used to declare a variable?

Accepted Answer

Dim

Answer

Set

Answer

Let

Answer

Var