Question

In an Excel document, which action should be taken if you want your information which falls across a selection of cells, to form part of one cell? Select all that apply:


Merge & center button.


Merge cells button. 


Merge across button.  


Align text center button.  

Answer 1

To combine information that falls across a selection of cells into one cell in Excel, you should use the following actions:

1. **Merge & Center button** - This will merge the selected cells and center the content.

2. **Merge cells button** - This will merge the selected cells without centering the content.

3. **Merge across button** - This will merge cells in each row across the selection, but not the entire selection itself if it's more than one row.

The **Align text center button** does not merge cells; it only centers the text within the currently selected cell(s).

So, the correct selections are:

- Merge & center button
- Merge cells button
- Merge across button