To select a range in using the name box
A) click in the name box and type the range address such as B15:D25 and then press "Enter".
B) select the name box from the 2010 File menu and choose "Range".
C) position the mouse pointer over the column headings holding the Alt key.
D) click in the first cell of the range, hold the "Ctrl" key, and then click in the last cell of the range.

Question

Quizplus · Accepted Answer

The correct way to select a range using the name box in Excel is to click in the name box, type the range address (for example, B15:D25), and then press "Enter". This action directly navigates to and selects the specified range.

To Select a Range in Using the Name Box