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:

Windows Defender

A built-in antivirus and anti-malware component of Microsoft Windows designed to protect computers from threats.

Antivirus

Software designed to detect, prevent, and remove malware, including viruses, from computers and networks.

Windows 10

The version of Microsoft’s operating system introduced in July 2015, known for features like the Start Menu, Cortana, and Universal Apps.

Windows Defender Firewall

A security feature of Microsoft Windows that monitors and controls incoming and outgoing network traffic based on predetermined security rules.