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

You want to be able to restrict values allowed in a cell and need to create a drop-down list of values from which users can choose. Which feature should you use?

Editorial Staff 0

You need to determine the commission earned by each Sales Rep, based on the Sales amounts in B3:B50 and the Commission rate specified in cell A1. You want to enter a formula in C3 and copy it down to C50. Which formula should you use?

Editorial Staff 0

Which value is returned when you enter this function into cell G2? =IF(SUM(F2:F6)>12,”Too Many Tardy Days”,”No Tardiness Issue”)

Editorial Staff 0