MCAS Macros & Automation

Question 1

Which tab in Microsoft Excel contains the Record Macro button?

Accepted Answer

View

Answer

Home

Answer

Insert

Answer

Formulas

Question 2

In Microsoft Office, what language are macros written in?

Accepted Answer

VBA (Visual Basic for Applications)

Answer

Python

Answer

JavaScript

Answer

C#

Question 3

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

Accepted Answer

Alt + F8

Answer

Ctrl + M

Answer

Alt + F11

Answer

Ctrl + Shift + M

Question 4

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

Accepted Answer

Alt + F11

Answer

Ctrl + F11

Answer

Shift + F11

Answer

Ctrl + Alt + V

Question 5

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

Accepted Answer

Absolute References

Answer

Relative References

Answer

Mixed References

Answer

Named References

Question 6

What file format must you use to save an Excel workbook that contains macros?

Accepted Answer

.xlsm

Answer

.xlsx

Answer

.xltx

Answer

.xlsb

Question 7

In the Trust Center settings, which option allows you to run macros from trusted sources while blocking others?

Accepted Answer

Disable all macros with notification

Answer

Disable all macros without notification

Answer

Enable all macros

Answer

Disable all macros except digitally signed macros