In a worksheet, column A contains employee last names, column B contains their middle initials (if any), and column C contains their first names. Which tool can combine the last names, initials, and first names in column D without using a worksheet formula?

  • Concatenation
  • Columns to Text
  • Flash Fill
  • AutoFill

The correct answer is:

  • Concatenation

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