If You Create a Recommended PivotTable on a Group of Data

question 64

Multiple Choice

If you create a Recommended PivotTable on a group of data about book sales with theses columns: Discipline (i.e.Business) , Area (i.e.Finance and Marketing) , Units Sold, Wholesale Price, what column might Excel use as values?

• A)Discipline
• B)Area
• C)Units Sold
• D)Both Discipline and Area

---

Definitions:

Sample Size

The number of observations or data points in a sample used to estimate characteristics of a population.

Population Standard Deviation

A measure that quantifies the amount of variation or dispersion of a set of values in a population.

Sampling Distribution

The statistical distribution that represents the probability of various outcomes, originating from a vast number of samples from a targeted population.

Standard Deviation

The square root of the variance showing how much individual data points differ from the mean.