To select a range by 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 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

Clicking in the name box and typing the range address followed by pressing Enter is the correct way to select a range using the name box. Option B is incorrect as there is no option to select Range directly from the File menu. Option C is incorrect as holding down the Alt key while positioning the mouse pointer over the column headings will hide the selected columns. Option D is incorrect as it is used to select non-adjacent cells.

To Select a Range by Using the Name Box