What is a contiguous data range?

Answer 1

A range of data made up of distinct values

Answer 2

A range of data uninterrupted by blank rows or columns

Answer 3

A range of data with no blank cells

Answer 4

Don’t know

Answer 5

Remove all blank rows and columns

Answer 6

Go to the Data tab and click the Make Contiguous button

Answer 7

Sort it so that all data types are together

Answer 8

Don’t know

Answer 9

It allows us to write better formulas

Answer 10

It allows us to use the range as a PivotTable data source

Answer 11

It allows us to sort and filter the data

Answer 12

Don’t know

How do we create a contiguous range?