FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
____ is a text function that joins together words, cell references, blank spaces, or numbers.
A
CONCATENATE
B
HIDE
C
Either A or B
D
None of the above
Explanation: 

Detailed explanation-1: -Use CONCATENATE, one of the text functions, to join two or more text strings into one string.

Detailed explanation-2: -The TEXTJOIN function combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the ranges.

Detailed explanation-3: -The CONCATENATE function in Excel is used to combine the text from different cells into one cell.

There is 1 question to complete.