Which feature allows you to divide the text in a single column into multiple columns in a spreadsheet?

Microsoft Excel Mcqs for PPSC, FPSC, NTS, and Pakistan government job tests. Select an option below, then read the explanation.

PPSCFPSCNTSPakistan govt jobs
Subject
Microsoft Excel Mcqscomputer-mcqs › microsoft-excel-mcqs
Published
21 Feb 2025
Last updated
28 May 2026

Browse all Microsoft Excel Mcqs

Choose the correct answer

Explanation

The 'Text to Columns' option found under the Data tab is used to separate the content of one column into several columns, such as splitting a full name into first and last names. The 'Sort & Filter' feature is designed for organizing and filtering data, not for splitting text. The 'Fill >> Justify' and 'Editing >> Justify' commands in the Home tab are related to text alignment and formatting, not dividing column data. For example, if a column contains "Ali Khan," using Text to Columns with a space delimiter will split it into "Ali" and "Khan" across two columns.

PakQuizHub — free MCQs and past papers for Pakistan government job tests. Content is for educational practice only.