A Relative Cell Reference

question 46

Multiple Choice

A relative cell reference:

• A)indicates a cell's specific location and the reference does not change when you copy the formula to another cell or range.
• B)contains both an absolute and a relative cell reference.
• C)indicates a cell's relative location from the cell containing the formula;the reference changes when you copy the formula.
• D)occurs when a formula directly refers to the cell containing the formula.

---

Definitions:

Immune Reaction

The body's defensive response to foreign substances or pathogens, involving recognition and attack mechanisms to protect against disease.

Chemical Barrier

A chemical barrier refers to a mechanism of defense provided by the secretion of chemicals that deter pathogens or predators.

Pathogens

microorganisms that cause diseases in their hosts.

Foreign Substance

Any material or substance that is not naturally part of an object or body and may be harmful or benign.