Question: 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
Answer: The correct answer of the above question is Option C:#REF!