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
What is a contiguous data range?
A range of data made up of distinct values
A range of data with no blank cells
A range of data uninterrupted by blank rows or columns
Don’t know
2
Beginner
How do we create a contiguous range?
Go to the Data tab and click the Make Contiguous button
Remove all blank rows and columns
Sort it so that all data types are together
Don’t know
3
Beginner
To create a contiguous range, we can enter values all the way down the column immediately next to multiple non-contiguous ranges. What is the main benefit of doing this?
It allows us to sort and filter the data
It allows us to use the range as a PivotTable data source
It allows us to write better formulas
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement