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:

Extraorganizational

Activities, processes, or relationships that exist or occur outside of an organization's own boundaries.

HR

Stands for Human Resources, a department within organizations focused on managing employee-related processes like hiring, training, and benefits administration.

CIM

Computer Integrated Manufacturing, an approach to manufacturing that integrates computer systems with physical manufacturing processes for efficiency and productivity improvements.

PLM

Product Lifecycle Management, a strategic approach to managing the series of changes a product goes through, from its design and development to its ultimate retirement.