When You Copy a Formula from Cell A10 to Cell

question 2

Multiple Choice

When you copy a formula from cell A10 to cell B10, what happens to the cell references in the formula?

• A) Excel places them on the Clipboard.
• B) Excel changes the cell references in the copied formula to reflect the new location of the formula.
• C) Excel bolds the cell references so you can change them.
• D) Excel displays a button near the copied cell with options for handling the cell references.

---

Definitions:

Long-Term Memories

A type of memory capable of storing large amounts of information for potentially unlimited durations, from days to decades.

Declarative Memories

Memories that can be consciously recalled, such as facts and events, and articulated.

Procedural Memories

The type of long-term memory that involves the unconscious memory of how to perform different actions and skills, essentially the memory of motor skills.

Implicit Memories

Memories that are not consciously recalled but influence behaviors and knowledge, such as skills and tasks.