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
Intermediate
What characteristics are required in the source data to create a PivotTable?
A list or table with values in it
The data must be housed in an Excel table or covered by a named range
A contiguous data range with headers
Don’t know
2
Intermediate
How do you remove an item from a PivotTable?
Drag it back from the Pivot fields into the field well
Right click the item in the field list and choose Remove
Delete it from the source data, then refresh the PivotTable
Don’t know
3
Intermediate
If you change something in your source data…
Then you must manually refresh your PivotTable in order to see the change show up there.
The PivotTable will update automatically.
You must close your workbook and re-open it to get the PivotTable to update.
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement