Elias wants to name his data in an Excel file. Each column of his data begins with a label. He follows these steps in order to create a name from labels. 1. Select the Formula tab. 2. Highlight any cell that includes the label. 3. In the Defined Names group, select "Create from Selection." 4. Select "Top row" in the Create Names from Selection pop-up box. Which step is incorrect?

Question

Guest

Computers & Technology

30 May, 21:06

Elias wants to name his data in an Excel file. Each column of his data begins with a label. He follows these steps in order to create a name from labels. 1. Select the Formula tab. 2. Highlight any cell that includes the label. 3. In the Defined Names group, select "Create from Selection." 4. Select "Top row" in the Create Names from Selection pop-up box. Which step is incorrect?

+4

Answers (1)

Know the Answer?

Nichols · Answer 1

1. Select the Formula tab

Explanation:

The Name Box in Excel is fastest way to create a named range:

-Select a cell or a range of cells that you want to name.

-Type a name into the Name Box.

-Press the Enter key.

Alas, a new Excel named range is created.