Question : What is/are the advantage/s of naming a range of cells?
Option 1: Names are easier to remember than cell coordinates
Option 2: Names make navigation in a worksheet easier
Option 3: Named ranges can be used throughout a workbook easily.
Option 4: All of the above
Correct Answer: All of the above
Solution :
Following are the advantages of naming a range of cells:
1. Names are easier to remember than cell coordinates,
2. Names make navigation in a worksheet easier,
3. Named ranges can be used throughout a workbook easily.
Hence, the correct option is 4.