DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Allows data in a series of cells to merge together
|
|
|
Merges 2 or more cells into one cell and centers it
|
|
|
Wraps the text in the cell
|
|
|
None of these
|
Detailed explanation-1: -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-2: -Merge cells 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.
Detailed explanation-3: -Join columns using the Merge Cells add-in for Excel With the Merge Cells add-in, you can combine data from several cells using any separator you like (e.g. space, comma, carriage return or line break). You can join values row by row, column by column or merge data from the selected cells into one without losing it.
Detailed explanation-4: -Combine cells using Excel’s Merge and Center feature The fastest and easiest way to combine two or more cells in Excel is to use the built-in Merge and Center option. The whole process takes only 2 quick steps: Select the contiguous cells you want to combine. On the Home tab > Alignment group, click the Merge & Center.