If formulas located in other cells reference cells in a deleted row or column,Excel does not adjust these cell references but instead displays the ____ error message.
A) #NULL!
B) #DIV/0!
C) #N/A
D) #REF!

Question

Quizplus · Accepted Answer

When Excel encounters a formula that references a deleted row or column, it cannot adjust the reference and instead displays the #REF! error message, indicating that the formula contains an invalid cell reference.

If Formulas Located in Other Cells Reference Cells in a Deleted