Question

What is a disadvantage of merging cells? Merging cells combines formatting styles. Once cells are merged the process cannot be reversed. Multiple cells can be combined into one reference. Data functions in multiple cells may not be recognized.

Answer 1

Answer: Data functions in multiple cells may not be recognized.

Step-by-step explanation:

When cells are merged on Excel, the data functions that were on the different cells that were merged may not be recognized in the merged cell so they will need to be inputted again.

This presents its own problem if the merged cells contained functions that had been used to calculate different things. The question then shifts to which function should stay in the merged cell out of the various functions that the composite cells had.