Jamie Wants to Be Able to Use Her PivotTable to Combine

question 140

Multiple Choice

Jamie wants to be able to use her PivotTable to combine items into groups.Which of the following is NOT true?

• A) Items that appear as row labels cannot be grouped.
• B) Items that appear as column labels can be grouped.
• C) If items are dates,they can be grouped automatically using the Grouping dialog box.
• D) If items are numbers,they can be grouped manually using the Ctrl key to select items in a group and then choosing Group from the shortcut menu.

---

Definitions:

Shifting Values

Refers to altering the numerical or categorical data points in a dataset, leading to changes in analysis outcomes.

σ

The symbol for standard deviation, a measure of the amount of variation or dispersion of a set of values.

Normal Distribution

A symmetric probability distribution centered on the mean, demonstrating that occurrences near the mean happen more often than those far from it.

Maximum Oxygen Uptake

The maximum rate at which an individual can consume oxygen during intense or maximal exercise, indicating cardiorespiratory fitness.