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

Question

Share Report Error

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

A. JOIN()

B. CONCAT()

C. TEXTJOIN()

D. CONCATENATE()

Answer: Option C

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

Share Report

What is the shortcut key sequence used to open the 'Find and Replace' dialog box with the 'Replace' tab directly active in MS Word?

A. Ctrl + G

B. Ctrl + R

C. Ctrl + H

D. Ctrl + F

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl + H opens the Find and Replace dialog box with the Replace tab active. Ctrl + F opens the Find pane, and Ctrl + G opens the Go To tab.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In Excel, to protect a worksheet from being edited, you can:

A. Review tab -> Protect Sheet

B. File -> Info -> Protect Workbook

C. View tab -> Lock

D. Home tab -> Format -> Protect

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Protect Sheet is under Review tab.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In MS Word, the 'Thesaurus' command is under which group in the Review tab?

A. Proofing

B. Language

C. Comments

D. Tracking

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The Thesaurus is in the Proofing group along with Spelling & Grammar, Word Count, etc.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs