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. TEXTJOIN()

C. CONCATENATE()

D. JOIN()

Answer: Option B

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

Which of the following elements in an MS Word window status bar allows users to quickly change the workspace magnification scale?

A. The Ribbon layout tabs

B. The Zoom Slider

C. The Scroll Lock indicator bar

D. The Quick Access Toolbar commands

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The Zoom Slider, located at the bottom-right corner of the Status Bar, allows users to increase or decrease the workspace magnification level quickly.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

Which layout master in MS PowerPoint is responsible for controlling the design properties, placeholder placements, header boundaries, and layout fields of printed slide notes sheets?

A. Notes Master

B. Slide Master

C. Presentation Blueprint Layout

D. Handout Master

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The Notes Master governs the design format rules, font selections, and alignment grids applied to speaker notes pages when printed out.

This question belongs to: Computer Microsoft Office