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 made up of distinct values
A range of data uninterrupted by blank rows or columns
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 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
© 2019 GoSkills Ltd.
Skills for career advancement