2. Using Range Names
Although ranges enable you to work efficiently with large groups of cells, there are some disadvantages to using range coordinates:
• Each time you want to use a range, you must check to see whether it still has the same coordinates (for example, one or more cells might have been inserted or deleted) and, if not, redefine its coordinates.
• Range notation is not intuitive. To know what a formula such as
=SUM(E6:E10) is adding, you have to look at the range itself.
• A slight mistake in defining the range coordinates can lead to disastrous results, especially when you’re erasing a range.
You can overcome these problems by using range names, which are labels applied ...