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

Computers and Technology

Damarion Pennington

26 July, 03:27

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?

+5

Answers (1)

Know the Answer?

Ariana Anderson · 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.