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
Something doesn’t seem right to you when you’re looking at the $74.15 for the Korean Beef Satays shown in the PivotTable below. How would you go about inspecting the records that contributed to this value?
Double-click the cell that contains the $74.15 value (highlighted in yellow)
It is not possible to do this easily
Go back to the source data table and filter the records consistently to show only Appetizers for the Category column, Korean Beef Satays for the Item Name column and 2 for the Week column
Don’t know
2
Advanced
If someone sent you a PivotTable, but deleted the original data source, how could you go about re-creating that data source?
Remove all row, column and report filters, remove all but one field from the values area of the PivotTable, and double-click that value cell
Right-click any value in the PivotTable and choose “Show Details”
You couldn’t
Don’t know
3
Advanced
The Show Details feature is very useful, but easy to accidentally trigger when using a PivotTable. If you wanted to prevent your users from accidentally drilling in to a data set and littering the workbook with extra worksheets, how would you do it?
Delete the original data table
Go to PivotTable Options > Data > uncheck the “Enable Show Details” checkbox
Turn on Excel’s worksheet protection feature to protect the PivotTable
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement