Which of the following utility options under the MS Excel Data tab allows developers to split a single column of text data into multiple columns using a delimiter like a comma? MCQ with Answer and Explanation

Question

Which of the following utility options under the MS Excel Data tab allows developers to split a single column of text data into multiple columns using a delimiter like a comma?

A. Text to Columns

B. Data Validation wizard

C. Consolidate tool

D. Flash Fill

Answer: Option A

Solution (By JKSSB Mock Tests)

The 'Text to Columns' wizard splits text strings from a single cell across multiple columns based on a specified delimiter (such as a tab, comma, or space) or a fixed character width.

This question belongs to: Computer Microsoft Office

Request complete Subject PDF

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1

Share Report

In Excel, which function returns the serial number of a specific date given year, month, day?

A. DATE()

B. DATEVALUE()

C. TODAY()

D. NOW()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
DATE(year, month, day) constructs a date.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In MS PowerPoint, what occurs when you click the 'B' key on the keyboard during an active, full-screen slide show presentation?

A. Launches the drawing pen annotation tool

B. Whites out the screen display completely

C. Blacks out the screen display completely

D. Moves the presentation instantly to the previous slide layout

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Pressing the 'B' key during a live presentation blacks out the screen. Pressing the 'W' key turns the screen completely white. Pressing either key again returns to the slide show.

This question belongs to: Computer Microsoft Office