Answer:
Option A: #REF
Explanation:
#REF error happen when there is an invalid cell reference in a formula.
For example, if we have an Excel formula: =A1 + B1. If the column B is removed and the formula will be broken and give #REF error because the Excel can't detect the existence of column B anymore.
#REF error can also happen when an Excel formula is copied to a new cell which will then affect the range of column or row defined in the formula. The original formula will reference to the rows or columns which are out of range.
