USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Replace cell references
|
|
|
Return ASCII values of characters
|
|
|
Concatenate and manipulate text
|
|
|
Show formula error value
|
Detailed explanation-1: -Text Formulas are fields that combine multiple text values into a single field, including values from other fields. Text formulas are very similar to equations and can be added as fields to objects within the “Schema” section in the Builder.
Detailed explanation-2: -The TEXT function lets you change the way a number appears by applying formatting to it with format codes. It’s useful in situations where you want to display numbers in a more readable format, or you want to combine numbers with text or symbols.
Detailed explanation-3: -Text manipulation is the process of using computer automation to modify text files on a large scale to suit the needs of the user. An example of this can include changing the first character of every word in a text document to uppercase.