Toggle navigation
GoSkills
Search for courses or lessons
Courses
For Teams
For Teams
Teach
Blog
Redeem a coupon
Start free trial
Search
Login
Quiz
1
Beginner
What is a contiguous data range?
A range of data uninterrupted by blank rows or columns
A range of data made up of distinct values
A range of data with no blank cells
Don’t know
2
Beginner
How do we create a contiguous range?
Remove all blank rows and columns
Go to the Data tab and click the Make Contiguous button
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 write better formulas
It allows us to sort and filter the data
It allows us to use the range as a PivotTable data source
Don’t know
Back to the top
© 2019 GoSkills Ltd.
Skills for career advancement