If Formulas Located in Other Cells Reference Cells in a Deleted

question 83

Multiple Choice

If formulas located in other cells reference cells in a deleted row or salumn, Excel does not adjust these cell references but instead displays the ____ error message.

• A) #NULL!
• B) #DIV/0!
• C) #N/A
• D) #REF!

---

Definitions:

Depression

A common and serious medical illness that negatively affects how you feel, the way you think, and how you act, leading to a variety of emotional and physical problems.

Correlational Studies

Research methods that examine the relationship between two or more variables to determine if a correlation exists.

Homosexuality

A sexual orientation characterized by romantic or sexual attraction to individuals of one's own sex.

Mental Health Workers

Professionals who provide services aimed at supporting individuals' mental and emotional well-being.