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:

Normative Influence

The impact others have on our behavior through norms or behaviors that are deemed acceptable by a group, leading individuals to conform in order to be liked or accepted.

Solomon Asch

A prominent psychologist known for his research on conformity, including his famous experiments demonstrating how people could be influenced to contradict their own accuracy for group consensus.

Halo Effect

The cognitive bias where the perception of one positive trait (such as attractiveness) leads to the unfounded assumption of other positive traits, such as intelligence or morality.

Rarity Principle

A concept in economics and marketing suggesting that rare or scarce items are perceived as more valuable.