MASTERING EXCEL PIVOTTABLES - SECTION 02 REVIEW QUIZ

Which tab would you use to show an average of your data in a PivotTable?

That's incorrect. The Insert Tab is where you add tables, illustrations, add-ins, charts, filters, text, and symbols.

Correct! You can add an average to the data in a Pivottable by going to the Analyze Tab and selecting Field Settings.

The REPORT LAYOUT button allows you to change the view to:

Your answers is incorrect because it is a partial answer. The REPORT LAYOUT button allows you to change the view to Compact Form but that is not all.

Your answers is incorrect because it is a partial answer. The REPORT LAYOUT button allows you to change the view to Outline Form but that is not all.

Your answers is incorrect because it is a partial answer. The REPORT LAYOUT button allows you to change the view to Tabular Form but that is not all.

Correct! The REPORT LAYOUT button allows you to change the view to Compact Form, Outline Form, or Tabular Form.

How do you use the GETPIVOTDATA function to fill in fields for you?

Correct! To use the GETPIVOTDATA function, click in a cell,type EQUALS (=), click on the cell you would like to grab data from; and press ENTER.

Your answer is incorrect. Clicking in a cell, selecting AutoSum in the Formulas Tab, and clicking average will not apply the GETPIVOTDATA function. It will, however set up an average.

Your answer is incorrect. Right clicking in a cell, selecting Format Cells, and select SPECIAL will not apply the GETPIVOTDATA function. It will, however allow you to format your cell to show a zip code, phone number, or social security number.