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

Digvijay Patil · Accepted Answer

Final Answer : D, Explanation :  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 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!

Definitions

Learning Objectives

Learning Objectives

Related questions

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/AD) #REF!

Definitions

Learning Objectives

Learning Objectives

Related questions

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!