Back to School Sale -
Enjoy
20% off all courses with code BTS2019
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 with no blank cells
A range of data uninterrupted by blank rows or columns
A range of data made up of distinct values
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 use the range as a PivotTable data source
It allows us to write better formulas
It allows us to sort and filter the data
Don’t know