DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which symbol is used to join the content of two or more cells?
|
|
+
|
|
|
:
|
|
|
$
|
|
|
&
|
Explanation:
Detailed explanation-1: -You can combine data from multiple cells into a single cell using the Ampersand symbol (&) or the CONCAT function.
Detailed explanation-2: -Select the cells to merge. Select Merge & Center. Important: When you merge multiple cells, the contents of only one cell (the upper-left cell for left-to-right languages, or the upper-right cell for right-to-left languages) appear in the merged cell. The contents of the other cells that you merge are deleted.
Detailed explanation-3: -Use CONCATENATE, one of the text functions, to join two or more text strings into one string.
There is 1 question to complete.