When You Copy and Paste a Formula with Absolute Cell

question 40

Short Answer

When you copy and paste a formula with absolute cell references, Excel substitutes new references to reflect the new formula location.

Calculate percentages associated with specific z-scores in a standard normal distribution.

Identify z-scores corresponding to specific percentiles in the distribution.

Interpret graphical representations of normal distributions to find percentages or probabilities.

Apply the empirical rule (68-95-99.7 rule) in real-world contexts.

---

Definitions:

Wheeler-Lea Act

The Wheeler-Lea Act is a United States federal law that amended the Federal Trade Commission Act, prohibiting unfair or deceptive acts or practices in commerce, with a particular focus on false advertising.

Federal Trade Commission

A U.S. government agency responsible for protecting consumers and promoting competition by preventing anticompetitive, deceptive, and unfair business practices.

Purchasing Power

The ability of an individual or group to buy goods or services, often relative to the amount of money they have.

Deflation

A decrease in the general price level of goods and services, often indicating reduced consumer demand or increased supply.