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
What is the best way to round a calculation in a PivotTable if you cannot add a new column to your source data?
Create a calculated field that contains a rounding formula
Create a column beside the PivotTable that contains a rounding formula
Create a calculated field that divides the two items, then format the column to hide decimals
Don’t know
2
Advanced
What is the most efficient way to modify a calculated field on a PivotTable?
Create a new Calculated Field that refers to the original one, but modifies it to be correct
Go to into the Calculated Field list, select the field from the list, and click Modify
Delete the Calculated Field, and set it up as a new Calculated Field
Don’t know
3
Advanced
Assume that you have just created a new Calculated Field for your PivotTable. What steps need to be taken to actually add it to the PivotTable?
None, it is added automatically
You need to drag it on to the PivotTable from the field list
You need to refresh the PivotTable first, then drag it on to the PivotTable from the field list
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement