MCAS Macros & Automation

Question 1

Which tab in Microsoft Excel contains the Record Macro button?

Accepted Answer

View

Answer

The View tab contains the Macros group, which includes the Record Macro button.

Question 2

In Microsoft Office, what language are macros written in?

Accepted Answer

VBA (Visual Basic for Applications)

Answer

Microsoft Office macros use VBA (Visual Basic for Applications) as their programming language.

Question 3

What is the keyboard shortcut to open the Macro dialog box in Excel?

Accepted Answer

Alt + F8

Answer

Alt + F8 opens the Macro dialog box, where you can run, edit, or delete macros.

Question 4

Which keyboard shortcut opens the Visual Basic Editor in Microsoft Office?

Accepted Answer

Alt + F11

Answer

Alt + F11 opens the Visual Basic Editor (VBE), where you can write and edit VBA code.

Question 5

When recording a macro in Excel, which reference type records the exact cell addresses used?

Accepted Answer

Absolute References

Answer

Absolute references record the exact cell addresses, so the macro always acts on those specific cells.

MCAS - Microsoft Certified Application Specialist Practice Test