USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
T
|
|
|
F
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -The CONCAT function requires at least one text argument to work. If any of the arguments is invalid (e.g. represented by another function that throws an error), an error will occur. The result of the CONCATENATE function is always a text string, even when you are combining numbers.
Detailed explanation-2: -Use CONCATENATE, one of the text functions, to join two or more text strings into one string.
Detailed explanation-3: -The word concatenate is just another way of saying “to combine” or “to join together". The CONCATENATE function allows you to combine text from different cells into one cell. In our example, we can use it to combine the text in column A and column B to create a combined name in a new column.