USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=concatenate(brain, storm)
|
|
|
=brain&storm
|
|
|
=combine(brain, storm)
|
|
|
=concatenate("brain", “storm")
|
Detailed explanation-1: -Concatenation is the process of appending one string to the end of another string. You concatenate strings by using the + operator. For string literals and string constants, concatenation occurs at compile time; no run-time concatenation occurs. For string variables, concatenation occurs only at run time.
Detailed explanation-2: -Use CONCATENATE, one of the text functions, to join two or more text strings into one string. Important: In Excel 2016, Excel Mobile, and Excel for the web, this function has been replaced with the CONCAT function.
Detailed explanation-3: -The append() method can be used to add strings together. It takes a string as a parameter and adds it to the end of the other string object. In the above example, we have passed str2 as a parameter to the append() function.
Detailed explanation-4: -In C, the strcat() function is used to concatenate two strings. It concatenates one string (the source) to the end of another string (the destination). The pointer of the source string is appended to the end of the destination string, thus concatenating both strings.