In Excel, which function is used to join text from multiple cells with a delimiter (Excel 2019/365)? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, which function is used to join text from multiple cells with a delimiter (Excel 2019/365)?

A. CONCAT()

B. JOIN()

C. CONCATENATE()

D. TEXTJOIN()

Answer: Option D

Solution (By JKSSB Mock Tests)

TEXTJOIN has a delimiter argument. CONCAT does not have delimiter.

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 MS Access, a query that asks the user to input a specific value each time it is run is called a:

A. Parameter query

B. Crosstab query

C. Select query

D. Action query

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
A parameter query prompts for criteria. Select query retrieves data, crosstab summarizes, action query updates/deletes.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In Excel, the error '#DIV/0!' occurs when:

A. Invalid reference

B. Name not recognized

C. Value not available

D. A formula divides by zero or an empty cell

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
#DIV/0! division by zero.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

What is the shortcut key to open the 'Find and Replace' dialog in MS Word with the Go To tab active?

A. Ctrl + H

B. Ctrl + G

C. Both A and C

D. F5

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl+G and F5 both open the Go To tab of Find and Replace.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs