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?

  • #VALUE!
  • a blank cell
  • #REF!
  • 0

The correct answer is:

  • #REF!

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