Jamie Wants to Use Her PivotTable to Show the Total

question 77

Multiple Choice

Jamie wants to use her PivotTable to show the total value of the cars for a series of car dealerships but she wants to filter the display to show only those dealers whose total stock of cars is greater than $1 million.How would she accomplish this?

• A) She would develop a PivotTable using the aggregate filter.
• B) She would develop a PivotTable using the report filter.
• C) She would develop a PivotTable using the category filter.
• D) She would develop a PivotTable using the value filter.

---

Definitions:

Quantity

A property that can exist as a multitude or magnitude, often measured and expressed as a number.

Confidence Interval

A range of values derived from sample data that is likely to contain the value of an unknown population parameter, with a specified level of confidence.

Population Variance

The measurement of how data points in an entire population are spread out from the mean of the population.

Standard Deviation

The measure of the dispersion or variability in a set of numbers, indicating how spread out the numbers are from the mean.