In Excel, which function is used to concatenate text strings? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, which function is used to concatenate text strings?

A. CONCAT

B. TEXTJOIN

C. CONCATENATE

D. All of the above

Answer: Option D

Solution (By JKSSB Mock Tests)

CONCAT, CONCATENATE, and TEXTJOIN all concatenate text (TEXTJOIN with 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 view in MS PowerPoint displays the speaker notes alongside a large preview of the active slide and a thumbnail preview of the upcoming slide?

A. Outline View

B. Reading View

C. Notes Page View

D. Presenter View

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Presenter View is a dedicated view designed for the presenter when projecting, showing the current slide, next slide, timer, and notes.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In PowerPoint, the 'Slide Sorter' view is used for:

A. Rearranging and organizing slides

B. Editing slide content

C. Viewing notes

D. Adding animations

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Slide Sorter shows thumbnails for ordering.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In MS Access, what is the purpose of the 'Database Documenter'?

A. Creates a user manual

B. Creates a report detailing the structure of selected database objects

C. Writes documentation for VBA code

D. Documents relationships

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Database Documenter prints object definitions.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs