If the Cell Reference $A5 in a Formula Is Copied

question 81

Multiple Choice

If the cell reference $A5 in a formula is copied and pasted over two columns and down two rows from its original cell, what the cell reference become in the new cell.

• A)$A5
• B)$A7
• C)$C5
• D)$C7

---

Definitions:

Mother

A female parent of biological, adoptive, or foster children, recognized for her role in child-rearing and emotional support.

Collective Unconscious

A part of the unconscious mind that is shared among beings of the same species, containing innate, universal predispositions.

Personal Unconscious

A term in Jungian psychology referring to a component of the mind containing forgotten or suppressed experiences unique to an individual.

Unconscious

The part of the mind that contains thoughts, memories, and desires not within current conscious awareness but can influence behavior.