USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
T
|
|
|
F
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -Merge cells 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. Tip: To merge cells without centering the data, click the merged cell and then click the left, center or right alignment options next to Merge & Center.
Detailed explanation-2: -20. To merge and center cells across multiple columns in Excel, and keep the data from the other cells, select the cells you want to merge and center, then press Ctrl + Shift + M followed by Ctrl + E, then Ctrl + Shift + M on your keyboard.
Detailed explanation-3: -Excel has a unique button called “Merge & Center, ” which is used to merge two or more different cells. When data is inserted into any merged cells, it is in the center position; thus, the name “Merge & Center.” On re-clicking on the button, it unmerges the cells.
Detailed explanation-4: -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.