MO-211 practice question 12 of 35
Which option helps to add a new sheet to a workbook?
Full set: 355 questionsDomain Insert and format text, shapes, and images
In Microsoft Excel, the command to add a new worksheet is located on the Home tab. Within the Cells group, the Insert dropdown menu contains the Insert Sheet option. Selecting this command adds a new, blank worksheet to the workbook. This is one of the primary methods for inserting sheets using the ribbon interface, alongside right-clicking a sheet tab and selecting "Insert" or using the "New sheet" plus (+) button.
B. Review: The Review tab contains tools for proofing, accessibility, comments, and workbook protection, not for adding sheets.
C. Format: The Format command in the Cells group is used to modify existing sheets, such as renaming or changing tab color.
D. Share: The Share functionality is for collaboration and sending the workbook to others, not for altering its structure.
1. Microsoft Corporation. (n.d.). Insert or delete a worksheet. Microsoft Support. Retrieved from support.microsoft.com. In the section "Insert a new worksheet," the official documentation states: "On the Home tab, in the Cells group, click Insert, and then click Insert Sheet."
2. University of Wisconsin-Madison. (2023). Excel - Working with Worksheets (Desktop). KnowledgeBase. In the "Inserting a Worksheet" section, the guide instructs: "From the Home tab, in the Cells group, click the arrow next to Insert and select Insert Sheet."
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?
