USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
allows you to combine text from different cells into one cell.
|
|
|
allows you to delete text from different cells into one cell.
|
|
|
used for counting cells within a specified range that meet a certain criterion, or condition.
|
|
|
perform a logical test and return one value for a TRUE result, and another for a FALSE result.
|
Detailed explanation-1: -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. Before we start writing the function, we’ll need to insert a new column in our spreadsheet for this data.
Detailed explanation-2: -Use CONCATENATE, one of the text functions, to join two or more text strings into one string.
Detailed explanation-3: -You can combine data from multiple cells into a single cell using the Ampersand symbol (&) or the CONCAT function.
Detailed explanation-4: -The CONCATENATE function in Excel is used to join different pieces of text together or combine values from several cells into one cell. The syntax of Excel CONCATENATE is as follows: CONCATENATE(text1, [text2], …) Where text is a text string, cell reference or formula-driven value.
Detailed explanation-5: -The string operator (&) can be used in formulas to concatenate, or join, two or more strings or the contents of referenced cells. Wildcards (*, ?, ) can be used in conditions to represent one or more characters. The & character is used to concatenate, or join, two or more strings or the contents of referenced cells.