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:

Balance Sheet

A document showcasing a business's assets, liabilities, and owner's equity at a certain point in time.

Rent Paid

The amount of money paid by a tenant to a landlord for the use of property or space over a specified period.

Capital

The financial resources businesses use to fund their operations, including equity, debt, and retained earnings.

Worksheet

A paper or digital document used to organize and summarize data for analytical, accounting, or other purposes, often facilitating easier decision-making.