Toggle navigation
GoSkills
Courses
Courses
Train your organization
Supercharge your organization with expert-led business and productivity courses.
Learn more
Learn on your own
Earn certifications for the most in-demand skills with unlimited access to all GoSkills courses.
Learn more
Explore our courses
Browse our award-winning library of 110+ business and productivity courses delivered in bite-sized lessons.
Explore courses
LMS
Course builder
Resources
Pricing
Organization pricing
Individual pricing
Pricing
Search
Sign up
Log in
Log in
Signup
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?
Sales $ and Category
Category and Burgers
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","Class","Alcohol")
=C2
=GETPIVOTDATA("Sales",$A$1,"Category","Bottled Beer")
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 “Not Found!”
It would return 445.15
It would return a #REF error
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement