GoSkills
Back to lesson
Question
1
of
3
1. 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?
Category and Burgers.
Category.
Sales $ and Category.
Don’t know
2. 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?
=GETPIVOTDATA("Sales",$A$1,"Category","Bottled Beer","Class","Alcohol")
=GETPIVOTDATA("Sales",$A$1,"Category","Bottled Beer")
=C2
Don’t know
3. You have the following PivotTable. On the same worksheet you also have a cell that includes the following formula: =IFERROR(GETPIVOTDATA("Sales",$A$1,"Category","Bottled Beer","Class","Alcohol"),"Not Found! ") What would happen to the GETPIVOTDATA function’s result if someone added a slicer to the PivotTable and filtered out the Food records so they didn’t show in the PivotTable?
It would return a #REF error.
It would return 445.15.
It would return “Not Found!”
Don’t know
Quiz progress
Previous
question
Next
question
Submit
answers
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement