FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
____ merges the selected cells into larger cells while keeping each row separate
A
Merge and Center
B
Merge Across
C
Either A or B
D
None of the above
Explanation: 

Detailed explanation-1: -Merge Across: merges the selected cells into larger cells while keeping each row separate.

Detailed explanation-2: -Click the first cell and press Shift while you click the last cell in the range you want to merge. Important: Make sure only one of the cells in the range has data. Click Home > Merge & Center. If Merge & Center is dimmed, make sure you’re not editing a cell or the cells you want to merge aren’t inside a table.

Detailed explanation-3: -Merge Across: This option combines the selected cells in each row individually. Merge Cells: This option joins the selected cells into a single cell without entering the text in the cell.

There is 1 question to complete.