Question

Allison and her group have completed the data entry for their spreadsheet project. They are in the process of formatting the data to make it easier to read and understand. The title is located in cell A5. The group has decided to merge cells A3:A7 to attempt to center the title over the data. After the merge, Allison points out that it is not centered and looks bad. Where would the title appear if Allison unmerged the cells in an attempt to fix the title problem?

Answer 1

Answer:

A3

Explanation:

Since the title that Alison's Group has made is located in cell A5 which is a merged cell that includes A3:A7 then un-merging these cells would move the title to cell A3 . That is because Excel always moves the information within merged cells to the beginning cell in that merger. Therefore since the beginning cell in this merger is A3 the title will automatically be moved and fit into that cell alone when un-merging.