You can define ranges as names from the Insert Menu. This makes subsequent enhancements and maintenance of the worksheet easy.
First, select the range of cells to which you wish to assign a name. Then INsert->Names->Define (below)
A dialog will appear as is shown below..
You can then use the defined names to specify a range in a table as shown in this example.
If you change the Range name, the formulas will adjust automatically.