As He Prepares His Assignment for His Marketing Class, Ted

question 23

Multiple Choice

As he prepares his assignment for his Marketing class, Ted goes to his friend Carter for help with PivotTables because Carter has had a lot of experience with them in his job.
-Ted wants to be able to analyze date data in his PivotTable by month.What must he do with the date field in his PivotTable?

• A)He must aggregate the data by the date field.
• B)He must cluster the data by the date field.
• C)He must sort the data by the date field.
• D)He must group the data by the date field.

---

Definitions:

Chemical Elements

Substances that cannot be broken down into simpler substances by chemical means, and are defined by the number of protons in their atomic nuclei.

Reddish Streak

The color mark left by a mineral when it is dragged across an unglazed porcelain plate.

Hematite

An iron oxide mineral that is one of the main ores of iron, recognized by its reddish-brown color.

Magnetite

A naturally occurring magnetic mineral, consisting of iron oxide, often mined as an iron ore.