If Formulas Located in Other Cells Reference Cells in a Deleted

question 81

Multiple Choice

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:

Advance in Technology

Advance in technology refers to the progressive development and innovation in technology that leads to more efficient processes, products, and services.

Human Capital

The economic value of an individual's skills, knowledge, and experience, considered in terms of the ability to perform labor to produce economic value.

Economic Cost

The total cost of choosing one action over another, including both explicit and implicit costs.