Question

In Excel, merging refers to

A combining data from several outside sources
B joining multiple worksheets in a workbook
C splitting the data in one cell into several smaller cells
D taking multiple cells and combining them into one large cell

Answer 1

D is the correct answer. In fact, A and B aren’t even operations in excel.

Answer 2

D taking multiple cells and combining them into one large cell

Step-by-step explanation:

In Excel you can combine data from multiple cells into a single cell using the ampersand symbol (&) or the CONCAT function.

Combine text from two or more cells into a single cell:

• Select the cell in which you will place the combined text.

• Type = and select the first cell you want to combine.
• Type & and use quotation marks with a space between them.

• Select the next cell you want to combine and press Enter. An example formula might be = A2 & "" & B2.