Microsoft Excel Excel Text to Columns and Data Cleanup

Question 1

On which Excel ribbon tab is the Text to Columns command located?

Accepted Answer

Data

Answer

Text to Columns sits in the Data Tools group of the Data tab.

Question 2

A column contains full names like Smith, John. Which Text to Columns option best splits them into last and first name columns?

Accepted Answer

Delimited with comma as the delimiter

Answer

The comma consistently separates the two parts, making a delimited split ideal.

Question 3

In the Text to Columns wizard, what does the option Treat consecutive delimiters as one do?

Accepted Answer

Prevents empty columns when several delimiters appear in a row

Answer

It collapses repeated delimiters so blank fields are not created.

Question 4

Which Excel function removes leading, trailing, and extra internal spaces from text?

Accepted Answer

TRIM

Answer

TRIM strips extra spaces, leaving single spaces between words.

Question 5

What is the purpose of the Destination box on the final step of the Text to Columns wizard?

Accepted Answer

To specify where the split data should be placed

Answer

Destination controls the top-left cell where the separated columns are written.

Excel Practice Test