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:

Micro Rest

Short periods of relaxation or downtime that help to rejuvenate the mind or body, enhancing overall productivity.

Instant Messaging

A method of communication that occurs in real-time among two or more individuals, utilizing typed text via the internet or a network.

Topic Sentences

Sentences that summarize the main idea of a paragraph, offering readers a clear overview of the content to follow.

Subheadings

Titles or headings used to organize content into sections within a document, making it easier to understand and navigate.