Macros & Automation Flashcards
7 cards from real MCAS practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Macros & Automation flashcards as text
Which tab in Microsoft Excel contains the Record Macro button?
Answer: View
The View tab contains the Macros group, which includes the Record Macro button.
In Microsoft Office, what language are macros written in?
Answer: VBA (Visual Basic for Applications)
Microsoft Office macros use VBA (Visual Basic for Applications) as their programming language.
What is the keyboard shortcut to open the Macro dialog box in Excel?
Answer: Alt + F8
Alt + F8 opens the Macro dialog box, where you can run, edit, or delete macros.
Which keyboard shortcut opens the Visual Basic Editor in Microsoft Office?
Answer: Alt + F11
Alt + F11 opens the Visual Basic Editor (VBE), where you can write and edit VBA code.
When recording a macro in Excel, which reference type records the exact cell addresses used?
Answer: Absolute References
Absolute references record the exact cell addresses, so the macro always acts on those specific cells.
What file format must you use to save an Excel workbook that contains macros?
Answer: .xlsm
The .xlsm format (Excel Macro-Enabled Workbook) is required to save workbooks containing macros.
In the Trust Center settings, which option allows you to run macros from trusted sources while blocking others?
Answer: Disable all macros with notification
Disable all macros with notification blocks macros but shows a security bar letting users enable them if trusted.