In Excel, what does the 'CONCATENATE' function do? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, what does the 'CONCATENATE' function do?

A. Compares two text strings

B. Splits text into separate columns

C. Converts text to uppercase

D. Joins two or more text strings into one

Answer: Option D

Solution (By JKSSB Mock Tests)

CONCATENATE combines multiple text strings into a single string. In newer versions, CONCAT or TEXTJOIN are also used.

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 PowerPoint, which tab is used to set slide transitions?

A. Animations

B. Design

C. Transitions

D. Slide Show

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The Transitions tab controls how slides change. Animations tab controls object movement.

This question belongs to: Computer Microsoft Office

Question #2

In MS Word, to create a bulleted list quickly, type an asterisk (*) and press:

A. Shift + Enter

B. Ctrl + Enter

C. Enter

D. Spacebar or Tab

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Typing * followed by Spacebar or Tab automatically starts a bulleted list (AutoFormat).

This question belongs to: Computer Microsoft Office

Question #3

What will be the output of the MS Excel formula =CEILING.MATH(14.2, 5)?

A. 10

B. 20

C. 15

D. 14

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The CEILING.MATH function rounds a number up to the nearest specified multiple. The nearest multiple of 5 greater than or equal to 14.2 is 15.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs