In a formula, you can use the name of a range instead of its
1 answer
cell reference. This can make formulas easier to read and understand. For example, instead of using =SUM(A1:A10), you could name the range "Sales" and use =SUM(Sales) in your formula. This way, when you look at the formula, you can easily see what data it is referencing.