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
Which of the following data characteristics is critical in order to allow efficient filtering of data?
Consistent data types in the column
No entirely blank rows in the data set
A good header row
Don’t know
2
Beginner
If you had a list of confectionery items in column A, what would be the most efficient route to find anything containing “Chocolate”?
Select the filter and type “choc” in the search box
Sort the data alphabetically, then visually scan the list.
Select the filter > Text filters > Contains and then enter “Chocolate”
Don’t know
3
Beginner
If you end up with too many filters on a table and lose confidence that all items are showing, which method would be quickest to give you the most confidence that all filters are reset?
Closing the workbook and re-opening it.
Clicking each filter arrow, and selecting Clear from the submenu
Turning off the filter, then re-applying it
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement