Excel Text to Columns and Data Cleanup Flashcards
6 cards from real Microsoft Excel practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 6 Excel Text to Columns and Data Cleanup flashcards as text
On which Excel ribbon tab is the Text to Columns command located?
Answer: Data
Text to Columns sits in the Data Tools group of the Data tab.
A column contains full names like Smith, John. Which Text to Columns option best splits them into last and first name columns?
Answer: Delimited with comma as the delimiter
The comma consistently separates the two parts, making a delimited split ideal.
In the Text to Columns wizard, what does the option Treat consecutive delimiters as one do?
Answer: Prevents empty columns when several delimiters appear in a row
It collapses repeated delimiters so blank fields are not created.
Which Excel function removes leading, trailing, and extra internal spaces from text?
Answer: TRIM
TRIM strips extra spaces, leaving single spaces between words.
What is the purpose of the Destination box on the final step of the Text to Columns wizard?
Answer: To specify where the split data should be placed
Destination controls the top-left cell where the separated columns are written.
Which Data tab command removes rows that are exact duplicates based on selected columns?
Answer: Remove Duplicates
Remove Duplicates deletes repeated rows using the columns you check.