DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
To combine strings ‘brain’ and ‘storm’ to form one string the function is
|
|
=concatenate(brain, storm)
|
|
|
=brain&storm
|
|
|
=combine(brain, storm)
|
|
|
=concatenate("brain", “storm")
|
Explanation:
Detailed explanation-1: -You can use the join() method to concatenate two or more strings in Python. It also allows you to concatenate strings separated by delimiters.
Detailed explanation-2: -Concatenation means joining strings together end-to-end to create a new string. To concatenate strings, we use the + operator. Keep in mind that when we work with numbers, + will be an operator for addition, but when used with strings it is a joining operator.
There is 1 question to complete.