Question

2. Be default, data in a merged cell is
aligned​

Answer 1

Answer:

First, we'll center text across cells by merging cells. To do this, select the cells you want to merge. In the “Alignment” section of the “Home” tab, click the “Merge & Center” button. The cells are merged and the text is centered in the single resulting cell.

Answer 2

Answer:

To change text control using the Format Cells dialog box:

Select a cell or range of cells.

Choose Format > Cells from the menu bar.

The Format Cells dialog box opens.

Click the Alignment tab.

Click the Wrapped Text, Shrink-to-Fit, or Merge Cells check boxes—or any combination of them—as needed.

Click OK

Explanation:

hope it helps you