MO-211 practice question 5 of 35
What is the shortcut key to insert a new worksheet in Excel?
Full set: 355 questionsDomain Insert and format text, shapes, and images
Both Shift + F11 and Alt + Shift + F1 are officially documented keyboard shortcuts in Microsoft Excel to insert a new worksheet into the active workbook. These shortcuts add a new sheet to the left of the currently selected sheet tab. The shortcut Ctrl + N, listed as option C, performs a different function; it creates an entirely new, blank workbook file, not a new worksheet within the existing file. Therefore, options B and D are the correct answers to the question.
A. Ctrl + Shift + N: This shortcut is not a default command in Excel for inserting a new worksheet. It is commonly used in other applications, like creating a new folder in File Explorer.
C. Ctrl + N: This shortcut creates a new, blank workbook (a separate .xlsx file), not a new worksheet within the currently open workbook.
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.
Specific Location: Under the "Ctrl key combination shortcuts" section
it lists Ctrl+N for "Create a new
blank workbook."
Specific Location: Under the "Function key shortcuts" section
it lists Shift+F11 to "Insert a new worksheet." It also lists Alt+Shift+F1 for the same action.
2. University of Wisconsin-Madison
Division of Information Technology (DoIT). (n.d.). Excel: Keyboard Shortcuts (PC). KB User's Guide. Retrieved from https://kb.wisc.edu/showcase/page.php?id=93553.
Specific Location: In the "Worksheet" section
the document lists Shift + F11 to "Insert a new worksheet." In the "Workbook" section
it lists Ctrl + N to "Create a new workbook."
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 6What is the shortcut key for copying a formula in Excel?
- Question 7How can you apply a custom number format to a cell in Excel?
