Which of the Following Is a Difference Between Relative Addressing

question 31

Multiple Choice

Which of the following is a difference between relative addressing and absolute addressing when using cell formulas in Excel?

• A) A relative address uses a dollar sign before either the row or column label; an absolute address uses the ampersand symbol before either the row or column label.
• B) A relative address uses a dollar sign before either the row or column label; an absolute address uses just the row and column label in the cell reference.
• C) A relative address uses just the row and column label in the cell reference; an absolute address uses a dollar sign before either the row or column label.
• D) A relative address uses only the column label in the cell reference; an absolute address uses the row.

---

Definitions:

Sampling Error

The discrepancy between a sample statistic and the true population parameter, which arises purely by chance.

Sample Size

Pertains to the count of items or participants chosen from a larger group for statistical examination.

Population

The total set of observations or elements from which samples can be drawn for statistical analysis.

Random Number Table

A table consisting of sequences of numbers generated in a random fashion, used for random sampling and simulation in statistical analysis.