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.
|
CONCATENATE
|
|
HIDE
|
|
Either A or B
|
|
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.