MCAS Macros & Automation 1 — Questions and Answers
Question 1: Which tab in Microsoft Excel contains the Record Macro button?
- Home
- Insert
- View (Correct answer)
- Formulas
Correct answer: View
The View tab contains the Macros group, which includes the Record Macro button.
Question 2: In Microsoft Office, what language are macros written in?
- Python
- JavaScript
- VBA (Visual Basic for Applications) (Correct answer)
- C#
Correct answer: VBA (Visual Basic for Applications)
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?
- Alt + F8 (Correct answer)
- Ctrl + M
- Alt + F11
- Ctrl + Shift + M
Correct answer: Alt + F8
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?
- Ctrl + F11
- Alt + F11 (Correct answer)
- Shift + F11
- Ctrl + Alt + V
Correct answer: Alt + F11
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?
- Relative References
- Absolute References (Correct answer)
- Mixed References
- Named References
Correct answer: Absolute References
Absolute references record the exact cell addresses, so the macro always acts on those specific cells.
Question 6: What file format must you use to save an Excel workbook that contains macros?
- .xlsx
- .xlsm (Correct answer)
- .xltx
- .xlsb
Correct answer: .xlsm
The .xlsm format (Excel Macro-Enabled Workbook) is required to save workbooks containing macros.
Question 7: In the Trust Center settings, which option allows you to run macros from trusted sources while blocking others?
- Disable all macros without notification
- Disable all macros with notification (Correct answer)
- Enable all macros
- Disable all macros except digitally signed macros
Correct answer: Disable all macros with notification
Disable all macros with notification blocks macros but shows a security bar letting users enable them if trusted.
MCAS Macros & Automation 1
Which tab in Microsoft Excel contains the Record Macro button?