PPSCFPSCNTSPakistan govt jobs
- Subject
- Microsoft Excel Mcqscomputer-mcqs › microsoft-excel-mcqs
- Published
- 21 Feb 2025
- Last updated
- 28 May 2026
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.
More Microsoft Excel Mcqs
Practice related questions from the same subject.
- 1.How many predefined margin settings are available by default in MS Excel?
- 2.Which feature in MS Excel enables you to assign custom names to cells or ranges in formulas without relying on selection?
- 3.In MS Word, the "Justify" alignment adjusts text to align evenly on both the left and right margins. How does the "Justify" alignment function in MS Excel?
- 4.Which keyboard shortcut allows you to jump directly to the last row in an Excel worksheet?
- 5.In MS Excel 2016, what is the label of the final column in a worksheet?
- 6.In Microsoft Excel, given a list of sales figures in column A, which formula will accurately return the second largest distinct value from that list?
- 7.In Microsoft Excel, which function is used to eliminate extra spaces from a text string, leaving only single spaces between words?
- 8.What is the primary purpose of the VLOOKUP function in Excel?
More in Computer Mcqs