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 have the PivotTable showing below and create a new formula by clicking = then selecting B4. What will the formula look like?
=GETPIVOTDATA("Sum of Units",$A$1)
=GETPIVOTDATA("Sum of Units",$A$1,"Category","Tarps and Groundsheets")
=B4
Don’t know
2
Advanced
You have the PivotTable showing below and create a new formula by clicking = then selecting B4. You then select Accessories from the Slicer. What will the formula return?
109
#REF!
#N/A
Don’t know
3
Advanced
Which formula would return 0 if the required components were filtered out of the source Pivot Table?
=IFERROR(GETPIVOTDATA("Sum of Units",$A$1,"Category","Tarps and Groundsheets"),0)
=IFERROR(GETPIVOTDATA("Sum of Units",$A$1,"Category","Tarps and Groundsheets"),"")
=IFREF(GETPIVOTDATA("Sum of Units",$A$1,"Category","Tarps and Groundsheets"),0)
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement