You inherited a workbook with a few PivotTables in it. On one worksheet you find a formula that reads =GETPIVOTDATA("Sales $",Report!$A$2,"Category","Burgers") Providing the formula is working, what fields can you guarantee you’ll see in the PivotTable field list?

Answer 1

Sales $ and Category

Answer 2

Category and Burgers

Answer 3

Don’t know

Answer 4

=GETPIVOTDATA("Sales",$A$1,"Category","Bottled Beer","Class","Alcohol")

Answer 5

=GETPIVOTDATA("Sales",$A$1,"Category","Bottled Beer")

Answer 6

Don’t know

Answer 7

It would return “Not Found!”

Answer 8

It would return 445.15

Answer 9

It would return a #REF error

Answer 10

Don’t know

You’ve got the PivotTable shown below. You click in a blank cell, type =, select C2 and hit Enter. What will the resulting formula be?