DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Merge 2 or more columns or rows using ____
|
|
Left
|
|
|
Center
|
|
|
Right
|
|
|
Merged Cells
|
Explanation:
Detailed explanation-1: -You can combine two or more table cells located in the same row or column into a single cell. For example, you can merge several cells horizontally to create a table heading that spans several columns. Select the cells that you want to merge. Under Table Tools, on the Layout tab, in the Merge group, click Merge Cells.
Detailed explanation-2: -Merge Cells Option With “Merge Cells” options users can combine multiple cells next to each other. It can merge cells across rows and columns as well. The command works similar to the “Merge & Center” option in Excel. However, the data aligns towards the left after merging.
Detailed explanation-3: -The correct answer is Merge Cells.
There is 1 question to complete.