Which of the Following Is True About Inserting Cells in a Worksheet

question 75

Multiple Choice

Which of the following is true about inserting cells in a worksheet?

• A) Excel automatically adjusts cell references to reflect new formula locations.
• B) You need to adjust cell references in all formulas that have moved.
• C) You cannot insert cells in a worksheet.
• D) Cells below the inserted cells are always moved downward.

---

Definitions:

Expected Frequency

The theoretical number of times an outcome is anticipated to occur in a statistical experiment based on the total number of observations and the probabilities of outcomes.

Uniformly Distributed

Describes a distribution where all outcomes are equally likely to occur.

Capital Punishment

A legal penalty where a person is sentenced to death by the state as punishment for a crime.

Poisson Distribution

A discrete probability distribution expressing the probability of a given number of events occurring in a fixed interval of time or space, assuming that these events occur with a known constant mean rate and independently of the time since the last event.