1. Where can a calculated column be used?

A. Excel calculation.

B. PivotTable Field List.

C. PivotTable Calculated Item.

D. PivotTable Calculated Field.

2. What happens when you use an aggregation function (i.e., SUM) in a calculated column?

A, It calculates a value based on the values in the row.

B.You receive an error.

C. It calculates a value based upon the entire column.

D. It turns the calculated column into a measure.

3. What is one of the Rules of a Measure?

A. Redefine the measure, don't reuse it.

B. Never use a measure within another measure.

C. Only use calculated columns in a measure.

D. Reuse the measure, don't redefine it.

4. What type of measure is created within the Power Pivot data model?

A. Implicit.

B. Exact.

C. Explicit.

D. Calculated Field.

5. What is the advantage of creating a SUM measure in the Data Model versus placing the field in the Values quadrant of the PivotTable? A. The SUM measure is "portable" and can be used in other measure calculations. B. It is more accurate than the calculation in the PivotTable. C. Once you connect a PivotTable to a data model, you can no longer add fields to the Values quadrant. D. It is the only way to add fields to the Values quadrant of a Power PivotTable.