What is the function of the CONCATENATE function in Excel? MCQ with Answer and Explanation

Question

Share Report Error

What is the function of the CONCATENATE function in Excel?

A. Removes extra spaces from text

B. Joins two or more text strings into one string

C. Converts text to uppercase

D. Extracts a specific number of characters from the left of a string

Answer: Option B

Solution (By JKSSB Mock Tests)

CONCATENATE combines text strings. UPPER converts to uppercase, TRIM removes extra spaces, LEFT extracts left characters.

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

What is the function of the keyboard shortcut Ctrl + J when working inside an active document in MS Word?

A. Applies center alignment formatting to the paragraph

B. Justifies the text alignment flush with both margins

C. Indents the paragraph from the left page margin

D. Inserts a clear hyperlink text reference field

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl + J applies Justify alignment, distributing spacing between words so that text aligns flush with both the left and right page margins.

This question belongs to: Computer Microsoft Office

Question #2

In PowerPoint, the keyboard shortcut to bring the selected object one step forward is:

A. Ctrl + F

B. Ctrl + Shift + F

C. Alt + F

D. Ctrl + ]

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl+Shift+F brings object forward (bring forward). Ctrl+Shift+B sends backward.

This question belongs to: Computer Microsoft Office

Question #3

In MS Word, what does a green wavy underline indicate?

A. Contextual spelling error

B. Possible grammatical error

C. Formatting inconsistency

D. Spelling mistake

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Green wavy underline flags grammar issues. Red wavy underline is spelling, blue for contextual spelling.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs