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