If you name a range of cells in Excel, you can use that name in a formula, or as the source for a data validation list, or as the data source for a pivot table.

You can also select the range, and use it to jump to specific cells when entering data, as in the [...]