Using Excel to Scrutinize the Impact of Changing Values in Cells

question 95

Multiple Choice

Using Excel to scrutinize the impact of changing values in cells that are referenced by a formula in another cell is called ____.

• A)verification seeking
• B)the IF function
• C)goal seeking
• D)what-if analysis

---

Definitions:

Probability

The measure of the likelihood that an event will occur, represented as a number between 0 and 1.

Exponentially Distributed

Pertains to a type of statistical distribution that describes the time between events in a process where events occur continuously and independently at a constant average rate.

Variance

Variance is a statistical measure that represents the dispersion or spread of a dataset by calculating the average of the squared differences from the mean, indicating how much the data points in a set differ from the mean value.

Exponential Distribution

A probability distribution that describes the time between events in a process where occurrences happen at a constant rate.