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:

Concentration

The amount of a substance in a given volume of solution or mixture or in a particular volume of space.

Solution

Homogeneous mixture formed when a solute is dissolved in a solvent.

Selectively Permeable

Describes membranes that allow certain substances to pass through while blocking others, crucial for cell function and homeostasis.

Plasma Membrane

The plasma membrane is a biological membrane that separates the interior of all cells from the outside environment, controlling the passage of substances.