Latest:
LinkedIn Microsoft Excel Certification 

Cell A2 contains the value 8 and cell B2 contains the value 9. What happens when cells A2 and B2 are merged and then unmerged?

Editorial Staff
  • Both values are lost.
  • Cell A2 contains the value 8 and cell B2 is empty.
  • Cell A2 contains the value 8 and cell B2 contains the value 9.
  • Cell A2 contains the value 17 and cell B2 is empty.

The correct answer is:

  • Cell A2 contains the value 8 and cell B2 is empty.

🎓 Get all the latest and 100% correct LinkedIn Microsoft Excel Skill Quiz Answers

You May Also Like

The AutoSum formulas in the range C9:F9 below return unexpected values. Why is this?

Editorial Staff 0

In the worksheet below, a table called Projects extends from cell A1 to D10. Cell D1 contains the text Status. Cell E12 contains the formula =Projects[@Status]. What does this formula return?

Editorial Staff 0

When using Goal Seek, you can find a target result by varying _____ at most.

Editorial Staff 0