If a Cell Containing the Formula =$B$14 Is Not Copy

question 73

Multiple Choice

If a cell containing the formula =$B$14 is not copy and pasted, but moved four columns over and four rows down, what would the resultant cell reference become?

• A)=F18
• B)=$F$18
• C)=B14
• D)=$B$14

---

Definitions:

Chi-Squared Distribution

A probability distribution that arises in statistics when a normal distribution is squared, commonly used in significance testing.

Degrees of Freedom

The count of distinct values or measures that can be allocated to a statistical distribution while adhering to all restrictions.

Chi-Squared Distribution

A probability distribution that is commonly used in hypothesis testing and models the distribution of sum of squares of independent standard normal random variables.

Chi-Square Distribution

A probability distribution that is used in statistical significance tests, especially for categorical data.