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
Beginner
You have a column and each cell contains “blue” or “red”. Which function will count how many cells contain “blue”?
COUNTA
COUNTUNIQUE
AVERAGE
Don’t know
2
Beginner
Can you add more than one “Columns” field to a pivot table?
Yes
No
Yes. “Columns” fields are automatically merged
Don’t know
3
Beginner
How do you sort the data in a pivot table by the “Values” field?
In “Rows” or “Columns” click “Sort by” and click the data from the “Values” field.
In “Values” click “Sort by”.
Click “Data” - “Sort pivot table”
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement