GoSkills
  • LMS
  • Course builder
  • Courses
    • Train your organization. Train your organization Supercharge your organization with expert-led business and productivity courses. Learn more
    • Learn on your own. Learn on your own Earn certifications for the most in-demand skills with unlimited access to all GoSkills courses. Learn more
    • Explore our courses. Explore our courses Browse our award-winning library of 100+ bite-sized business and productivity courses.  Explore courses
  • Courses
  • Resources
  • Pricing
    • Organization pricing
    • Individual pricing
  • Pricing
  • Search
Sign upLog in
  • Log in Signup

Quiz

  1. 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?

  2. 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?

    Supporting image for quiz question

    Supporting image for quiz question
  3. 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?

    Supporting image for quiz question

    Supporting image for quiz question
Previous question Previous Next question Next
Give feedback

How is your GoSkills experience?

I need help

Your feedback has been sent

Thank you

Back to the top

© 2023 GoSkills Ltd. Skills for career advancement