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

Question
In Excel, what does the 'CONCATENATE' function do?
A. Compares two text strings
B. Joins two or more text strings into one
C. Converts text to uppercase
D. Splits text into separate columns
Answer: Option B
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 MS PowerPoint, which tool allows an author to copy an animation sequence from one design asset and apply it to another object with a single click?
A. Format Painter
B. Transition Manager properties
C. Animation Painter
D. Trigger configuration
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The Animation Painter tool copies animation effects from a selected object and applies them to another target object, streamlining the design process.
This question belongs to: Computer Microsoft Office
Question #2
To quickly summon the 'Save As' dialog box in MS Office, press:
A. Alt + F2
B. F12
C. Ctrl + S
D. Shift + F12
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
F12 opens Save As. Ctrl + S saves the file (or Save As if never saved). Shift + F12 also saves (same as Ctrl+S). Alt+F2 opens Save As in some versions, but F12 is standard.
This question belongs to: Computer Microsoft Office
Question #3
What is the function of the keyboard shortcut Ctrl + J when working inside an active document in MS Word?
A. Justifies the text alignment flush with both margins
B. Indents the paragraph from the left page margin
C. Applies center alignment formatting to the paragraph
D. Inserts a clear hyperlink text reference field
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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
Explore All Microsoft Office MCQs
Today's Top Topics
Memory and Storage Devices 438 Computer Networking 325 Computer Abbreviations 369 Database Management System (DBMS) 278 CPU (Central Processing Unit) 327
Explore Subjects
Maths 5575 Geography GK 6121 Economy GK 2220 History GK 3374 Accountancy and Statistics 3179
Practice Mix
The 'Deccani' style of painting developed in:
He ___ be very upset; he's not talking to anyone.
Which cloud type appears as thin, feathery streaks?
Two numbers are in the ratio 4:8 and their sum is 512. Find the numbers.
By the time you return, I ________ the house.