Question

The name for a range is entered in the

A. Name box
B. New Name dialog Box
C. Formula bar
D. Cell​

Answer 1

To create a named range, simply select a cell or cell range, then type the desired name into the Name box (to the left of the formula bar). You can then use the new name whenever you want to refer to that cell range. Watch the video below to learn how to create and use named ranges.

Answer 2

Explanation:

Create Excel names that refer to cells, a constant value, or a formula. Use names in formulas, or quickly select a named range.