In Excel, which function joins text from multiple ranges with a delimiter? (Available in Excel 2019/365) MCQ with Answer and Explanation

Question
In Excel, which function joins text from multiple ranges with a delimiter? (Available in Excel 2019/365)
A. CONCATENATE()
B. JOIN()
C. CONCAT()
D. TEXTJOIN()
Answer: Option D
Solution (By JKSSB Mock Tests)
TEXTJOIN combines text with a delimiter and can ignore empty cells. CONCATENATE and CONCAT do not have delimiter parameter.
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
In MS PowerPoint, which pane allows you to add speaker notes?
A. Slides pane
B. Task pane
C. Notes pane
D. Outline pane
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The Notes pane (below the slide in Normal view) is where you type speaker notes. Outline pane shows text outline.
This question belongs to: Computer Microsoft Office
Question #2
In Excel, the function =VLOOKUP(102, A2:C10, 2, FALSE) searches for 102 in:
A. The row 102
B. The second column
C. The first column of the range A2:C10
D. The entire range
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
VLOOKUP searches the first column of the table_array.
This question belongs to: Computer Microsoft Office
Question #3
Which MS Excel tool lets you import raw text file lines and split them across multiple distinct worksheet columns using a delimiter like a comma or tab?
A. Flash Fill
B. Data Validation
C. Text to Columns
D. Merge Cells
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The 'Text to Columns' wizard splits text strings from a single cell across multiple columns using defined delimiters or fixed character widths.
This question belongs to: Computer Microsoft Office
Explore All Microsoft Office MCQs
Today's Top Topics
Computer Software 347 Internet and Web Technologies 461 Computer Fundamentals 326 Microsoft Office 1199 CPU (Central Processing Unit) 327
Explore Subjects
Computer 5279 Static General Knowledge 6362 English 15164 Current Affairs 575 History GK 3374
Practice Mix
The difference between simple interest and compound interest on a certain sum of money for 2 years at 9% per annum is Rs. 81. Find the sum.
The process by which plants lose water in the form of liquid droplets is:
The 'Vote on Account' is used to:
Software programs that are custom engineered for banking automated teller machines (ATMs) to connect securely to institutional transaction ledger networks are classified as:
Which is the capital of South Africa (legislative)?