MO-211 practice question 5 of 35

What is the shortcut key to insert a new worksheet in Excel?

Full set: 355 questions

Domain Insert and format text, shapes, and images

Answer options
A: Ctrl + Shift + N
B: Alt + Shift + F1 Correct answer
C: Ctrl + N
D: Shift + F11 Correct answer
Correct Answer:
B. Alt + Shift + F1; D. Shift + F11
Explanation

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.

Why Incorrect

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.

References

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."

Scroll to Top