The label Souvenir Shop is in cell A1, and April Sales Report is in cell B1. You select the range A1:E1 and click Merge & Center.
What is the result?
○ Souvenir Shop is centered over the range A1:E1, and April Sales Report is deleted.
O Excel does not let you merge and center a range of cells where those cells each contain data.
O Souvenir Shop is centered over the range A1:E1, and April Sales Report is moved to cell F1.
O Souvenir Shop is combined with April Sales Report. The new combined label is then centered over the range A1:E1.



Answer :

When you select a range of cells in Excel for merging and use the "Merge & Center" feature, the following happens: - Excel merges all the selected cells into a single larger cell. - The content of the upper-left cell in the selected range is kept. - The contents of all other cells in the selected range are deleted. - The content from the upper-left cell is centered across the newly merged cell. In the scenario you've described, "Souvenir Shop" is in cell A1 and "April Sales Report" is in cell B1. If you select the range A1:E1 and then click "Merge & Center," this is what will happen: - Cells A1 through E1 will be merged into one large cell. - The text "Souvenir Shop" from cell A1 will be kept since it is in the upper-left cell of the selected range. - The text "April Sales Report" from cell B1, along with any other content in cells C1, D1, and E1, will be deleted. - The text "Souvenir Shop" will be centered across the newly merged cell that now spans from column A to column E. Therefore, the correct result is: ○ Souvenir Shop is centered over the range A1:E1, and April Sales Report is deleted.

Other Questions