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

Respuesta :

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

Answer:

D taking multiple cells and combining them into one large cell

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.