If a Cell Containing =B$14 Is Copied and Pasted Three

question 26

Multiple Choice

If a cell containing =B$14 is copied and pasted three columns over and two rows down, what would the resultant cell reference become?

• A) E$14
• B) $E$14
• C) B16
• D) B$16

---

Definitions:

Availability Heuristic

A mental shortcut that relies on immediate examples that come to a person's mind when evaluating a specific topic, concept, method or decision.

Welfare Fraud

The act of illegally using or obtaining government assistance benefits by knowingly providing false information or withholding information.

Welfare Abuse

The misuse or fraudulent use of government assistance programs designed to help those in need.

Planning Fallacy

The tendency to underestimate the amount of time, costs, and risks involved in a project and overestimate the benefits.