Question

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?

Answer 1

1. Select the Formula tab

Step-by-step 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.