Toggle navigation
GoSkills
Search for courses or lessons
Courses
For Teams
For Teams
Teach
Blog
Redeem a coupon
Start free trial
Search
Login
Quiz
1
Advanced
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.
Category and Burgers.
Sales $ and Category.
Don’t know
2
Advanced
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")
=GETPIVOTDATA("Sales",$A$1,"Category","Bottled Beer","Class","Alcohol")
=C2
Don’t know
3
Advanced
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 445.15.
It would return “Not Found!”
It would return a #REF error.
Don’t know
Back to the top
© 2019 GoSkills Ltd.
Skills for career advancement