GoSkills
Back to lesson
Question
1
of
3
1. What is a contiguous data range?
A range of data uninterrupted by blank rows or columns
A range of data with no blank cells
A range of data made up of distinct values
Don’t know
2. How do we create a contiguous range?
Go to the Data tab and click the Make Contiguous button
Sort it so that all data types are together
Remove all blank rows and columns
Don’t know
3. 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
Quiz progress
Previous
question
Next
question
Submit
answers
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement