Question

What is the use of 'Merge and Center' feature in MS Excel?
1. It adds numeric values from two cells
2. It joins two words from two cells
3. It combines two cells into one cell
4. It calculates total of a range of cells

Answer 1

Correct Answer - Option 3 : It combines two cells into one cell

The correct answer is ​It combines two cells into one cell.

• 'Merge and Center' feature in MS Excel combines two cells into one cell.

 

• Merge & Center is a feature in excel that combines multiple cells and centers the contents of the first cell.
  • Rows and columns can also be merged using his feature.
  • This is used to combine multiple cells into a single cell and create the main headers for Excel dashboards in Microsoft Excel.
  • Shortcut to merge two or more cells in excel- select the cells to be merged, and use Alt > H > M > C sequentially.