DATABASE FUNDAMENTALS
WORKBOOK THEMES
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Center
|
|
Merge
|
|
Merge & Center
|
|
Wrap Text
|
Detailed explanation-1: -The correct answer is Merge Cells tool. Merge Cells tool is used to create headings that spread across multiple columns. First, use the Layout tab to access the Merge Cells button.
Detailed explanation-2: -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-3: -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-4: -To merge a group of cells and center the text, you can also use the Merge and Center button on the Excel tool bar.