DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Clicking this icon after selecting the range, will result in all selected cells merging into one larger cell.
|
|
Merge and Center
|
|
|
Center
|
|
|
Wrap Text
|
|
|
FlashFill
|
Explanation:
Detailed explanation-1: -To merge a group of cells and center the text, you can also use the Merge and Center button on the Excel tool bar.
Detailed explanation-2: -Press “C” (shortcut) if you want to merge and center the selected cells in Excel.
Detailed explanation-3: -Select the range of cells over which you want to center text. Right-click the selected cells, and then click Format Cells. Click the Alignment tab. In the Horizontal list, click Center Across Selection.
Detailed explanation-4: -Click the first cell and press Shift while you click the last cell in the range you want to merge.
There is 1 question to complete.