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. Joins two or more text strings into one string

B. Converts text to uppercase

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

D. Removes extra spaces from text

Answer: Option A

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

Share Report

Which component of an MS Access window layout allows database administrators to define specific rules that prevent invalid entries before records are saved?

A. Format properties sheet

B. Validation Rule

C. Default Value mapping

D. Input Mask editor

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The Validation Rule property evaluates data entries against specified criteria constraints, blocking invalid inputs before they are saved to the database table.

This question belongs to: Computer Microsoft Office