MO-211 practice question 9 of 35

Which of the following features helps you split data in a cell into multiple columns?

Full set: 355 questions

Domain Insert tables, charts, SmartArt, 3D models, and media

Answer options
A: Split cells Correct answer
B: Merging cells
C: Formatting data
D: Wrapping text
Correct Answer:
A. Split cells
Explanation

The feature designed to split the contents of a cell into multiple columns is officially named "Text to Columns" in Microsoft Excel. This tool parses data within a single column based on a specified delimiter (such as a comma, space, or tab) or a fixed width and distributes the resulting pieces of data into adjacent columns. Option A, "Split cells," while not the official feature name, accurately describes the outcome of this operation and is the only plausible choice among the given options.

Why Incorrect

B. Merging cells: This action is the opposite; it combines two or more cells into a single, larger cell.
C. Formatting data: This changes the visual appearance of data (e.g., font, color, number style) but does not alter its location or split it across cells.
D. Wrapping text: This feature displays long text on multiple lines within the same cell to improve readability, without splitting the data into new columns.

References

1. Microsoft Corporation. (n.d.). Split text into different columns with the Text to Columns Wizard. Microsoft Support. Retrieved from https://support.microsoft.com/en-us/office/split-text-into-different-columns-with-the-text-to-columns-wizard-30b14928-5550-41f5-97ca-7a3e9c363ed7.

Reference Point: The document's title and first paragraph explicitly state

"You can take the text in one or more cells

and spread it out across multiple cells. This is the opposite of concatenation... For example

you can split a column of full names into separate first and last name columns." This directly supports the function described in the question.

2. University of Wisconsin-Madison. (n.d.). Excel - Splitting Text into Multiple Columns/Cells. KnowledgeBase. Retrieved from https://kb.wisc.edu/showcase/page.php?id=92519.

Reference Point: The "Overview" section describes the "Text to Columns" feature as the primary method for "splitting the contents of a cell into multiple cells." This aligns with the correct answer's function.

3. MIT Libraries. (n.d.). Excel 2016: Text to Columns. Data Management Services. Retrieved from https://libguides.mit.edu/c.php?g=176258&p=1159402.

Reference Point: The guide explains

"Text to Columns is a feature in Excel that allows you to split a column of text into multiple columns." This confirms the purpose of the feature.

Scroll to Top