What is the easiest way to create a PivotTable?

Answer 1

Go to Insert > PivotTable > Select your data

Answer 2

Select your data > Turn it into an official Excel Table > Insert > PivotTable

Answer 3

Select a cell inside your data range > Insert > PivotTable

Answer 4

Don’t know

Answer 5

Class on Columns, Category on Rows, Sales $ on Values

Answer 6

Category on Rows, Sales on Rows, Class on Columns

Answer 7

Class on Rows, Category on Columns, Sales $ on Values

Answer 8

Don’t know

Answer 9

Close and re-open the file

Answer 10

Right-click any cell in the PivotTable and choose Refresh

Answer 11

Select a cell in the PivotTable > Data tab > Refresh > Refresh

Answer 12

Don’t know

Assume that our data source has only three fields: Class (containing Alcohol and Food), Category (Appetizers, Bottled Beer, etc…) and Sales $. How would you configure the PivotTable shown below?