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
Which is the best method to round a calculation in a Pivot Table if a new column can't be added to the source data?
Create a calculated field that contains a rounding formula
Create a column beside the Pivot Table that contains a rounding formula
Create a calculated field that divides the two items, and then format the column to hide decimals
Don’t know
2
Advanced
Which is the most efficient method to modify a calculated field in a Pivot Table?
Go to into the Calculated Field list, select the field from the list, and click Modify
Create a new Calculated Field that refers to the original one but that modifies it to be correct
Delete the Calculated Field, and set it up as a new Calculated Field
Don’t know
3
Advanced
Suppose you've just created two new Calculated Fields for your Pivot Table called Profit and Profit %. What steps are required for them to be added to the Pivot Table as shown here?
You need to drag it on to the Pivot Table from the field list
You need to refresh the Pivot Table first, then drag it on to the Pivot Table from the field list
No steps are required, as the new Calculated Field is added automatically
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement