Question

what is the advantage of defining range name

Answer 1

Explanation:

Advantages to Naming Cells and Ranges. Using names for cells and ranges offers the following advantages: A meaningful range name (such as Income) is much easier to remember than a range address (such as A1:A21). After you select a named cell or range, its name appears in the name box.