QUESTION 2

Question

The Text to Columns function in Excel is primarily used for:

Splitting a single column of text into multiple columns based on a delimiter or a fixed width.

Concatenating multiple columns into a single column.

Changing the font style and size of selected text.

Applying conditional formatting to specific cells.

Answer 1

The correct answer is: Splitting a single column of text into multiple columns based on a delimiter or a fixed width.