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?
Step 1: The Data tab should be selected since it contains the Defined Names section.
Step 2: The entire data range must be selected to create names from labels.
Step 3: “Create from Selection” should be selected in the Data Tools group.
Step 4: “Top column,” not “Top row,” should be selected in the pop-up box.