FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -The fastest and easiest way to combine two or more cells in Excel is to use the built-in Merge and Center option. The whole process takes only 2 quick steps: Select the contiguous cells you want to combine. On the Home tab > Alignment group, click the Merge & Center.

Detailed explanation-2: -You can combine two or more table cells located in the same row or column into a single cell. For example, you can merge several cells horizontally to create a table heading that spans several columns. Select the cells that you want to merge. Under Table Tools, on the Layout tab, in the Merge group, click Merge Cells.

Detailed explanation-3: -Merge Cells Option With “Merge Cells” options users can combine multiple cells next to each other. It can merge cells across rows and columns as well. The command works similar to the “Merge & Center” option in Excel. However, the data aligns towards the left after merging.

Detailed explanation-4: -The correct answer is Merge Cells. First, use the Layout tab to access the Merge Cells button. Second, use the Merge cells option found on the context menu when you right-click on the selected table cells.