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. CONCATENATE

B. All of the above

C. CONCAT

D. TEXTJOIN

Answer: Option B

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

In MS PowerPoint, what is the difference between a 'Theme' and a 'Template'?

A. Theme is for slides, Template is for handouts

B. They are the same

C. A Template includes colors, fonts, and effects; a Theme includes content

D. A Theme includes colors, fonts, and effects; a Template includes content and layout

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
A Theme is a set of design elements (colors, fonts, effects). A Template is a file that includes a theme, slide layouts, and often content placeholders or sample content to provide a starting point.

This question belongs to: Computer Microsoft Office

Question #2

In Excel, the 'PMT' function calculates:

A. Interest rate

B. Future value

C. Present value

D. Loan payment amount

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
PMT returns periodic payment.

This question belongs to: Computer Microsoft Office

Question #3

In Excel, the formula =$A1 is an example of:

A. Relative reference

B. Mixed reference (column absolute, row relative)

C. Absolute reference

D. Circular reference

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
$A locks column A, row remains relative.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs