FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Select the cell where you want to put the combined data. Type = and select the first cell you want to combine. Type & and use quotation marks with a space enclosed. Select the next cell you want to combine and press enter.

Detailed explanation-2: -Merge Cells is an add-in for Microsoft Excel that combines multiple text cells. Use it to join values from several cells to one and merge several cells, rows, or columns keeping all data.

Detailed explanation-3: -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. Second, use the Merge cells option found on the context menu when you right-click on the selected table cells.

Detailed explanation-4: -Inside the Format Cells menu, click on the Alignment tab and tick the box that says Merge Cells.