MO-211 practice question 12 of 35

Which option helps to add a new sheet to a workbook?

Full set: 355 questions

Domain Insert and format text, shapes, and images

Answer options
A: Insert Correct answer
B: Review
C: Format
D: Share
Correct Answer:
A. Insert
Explanation

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.

Why Incorrect

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.

References

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

Scroll to Top