What is a contiguous data range?

Answer 1

A range of data uninterrupted by blank rows or columns

Answer 2

A range of data with no blank cells

Answer 3

A range of data made up of distinct values

Answer 4

Don’t know

Answer 5

Sort it so that all data types are together

Answer 6

Remove all blank rows and columns

Answer 7

Go to the Data tab and click the Make Contiguous button

Answer 8

Don’t know

Answer 9

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

Answer 10

It allows us to write better formulas

Answer 11

It allows us to sort and filter the data

Answer 12

Don’t know

How do we create a contiguous range?