MO-211 practice question 22 of 35
What is the keyboard shortcut to run a macro in Excel?
Full set: 355 questionsDomain Manage presentations
The keyboard shortcut Alt+F8 opens the Macro dialog box in Microsoft Excel. This dialog box lists all available macros in the current workbook and other open workbooks. From this window, the user can select a specific macro and choose to run, edit, step into, or delete it. While individual macros can be assigned their own Ctrl (or Ctrl+Shift) shortcut keys during creation, Alt+F8 is the universal shortcut to access the main macro management interface.
A. Ctrl+Shift+M: This is not a default Excel shortcut for running macros. It is sometimes associated with adding a new worksheet in older versions or can be custom assigned.
B. Ctrl+Alt+H: This shortcut is not assigned to any macro-related function in Excel. Ctrl+H opens the Find and Replace dialog box.
D. Ctrl+Alt+R: This is not a standard Excel shortcut. The Ctrl+R shortcut is used to fill the selected cells to the right.
1. Microsoft Corporation. (n.d.). Keyboard shortcuts in Excel. Microsoft Support. Retrieved from https://support.microsoft.com/en-us/office/keyboard-shortcuts-in-excel-1798d9d5-842a-42b8-9c99-9b7213f0040f.
Reference Specifics: In the section "Ctrl key combination shortcuts
" the documentation lists Alt+F8 as the shortcut to "Display the Macro dialog box to create
run
edit
or delete a macro."
2. University of Wisconsin-Madison. (n.d.). Excel - Keyboard Shortcuts. Division of Information Technology (DoIT). Retrieved from https://it.wisc.edu/services/online-training-for-faculty-staff-and-students/courses/excel-keyboard-shortcuts/.
Reference Specifics: Under the "Macros" section
the document lists Alt + F8 to "Open the Macro dialog box."
Keep practicing
Take the free MO-211 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other MO-211 practice questions
- Question 1What formula can be used to calculate the sum of a range of cells in Excel?
- Question 2Which chart type is best used to display trends over time?
- Question 3What is the formula used in Excel to calculate the percentage change between two numbers?
- Question 4What is a slicer in Excel?
- Question 5What is the shortcut key to insert a new worksheet in Excel?
- Question 6What is the shortcut key for copying a formula in Excel?
