easyFPSCNTSCSSPPSCMS Office & Productivity
Answer explanation
Explanation included
Practice quiz ready
Question

How to split a single columns’ text into multiple columns?

AData>>Sort & Filter
BData>>Text to Columns
CHome>>Fill>>Justify
DHome>>Editing>>Justify

Choose an option to check yourself, or reveal the answer and explanation instantly.

Continue practising this MCQ topic

Use these links to review the full topic, start a timed quiz, or open the exam hub connected with this question.

Previous
What is a group of cells called in Excel?
Next
Which function allows to define names/text in formulas except the use of selection in MS Excel?

Related MS Office & Productivity MCQs

View all

Test Yourself

Take a full quiz on MS Office & Productivity

Start Quiz

Exam Coverage

Trust

Answer is visible after reveal
Explanation helps learning
Free topic quiz available

Subject

MS Office & Productivity

Save your progress

Create a free account to bookmark MCQs and track weak areas.

Register Free
Start QuizNext MCQ
Answer and explanation

Correct Answer: B: Data>>Text to Columns

Explanation: The correct answer is B: Data>>Text to Columns. To split a single column's text into multiple columns in Excel, use DATA >> TEXT TO COLUMNS — it divides text into separate columns.

Continue practice

More MS Office & Productivity MCQs with answers

Use these links to review related questions, practise the full topic, or open the exam preparation pages connected with this MCQ.

Related questions

Topic and exam paths