FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

WORKBOOK THEMES

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Use the ____ button to put a label in the middle across several columns?
A
Center
B
Merge
C
Merge & Center
D
Wrap Text
Explanation: 

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.

There is 1 question to complete.