Question

Create defined names for range B3:E6 using the Create from Selection command. Use the titles in the Top Row of the selection as the range names. Select the Manager range using the Name Box.

A) Define Names
B) Name Manager
C) Create from Selection
D) Select Range Titles

Answer 1

To define names for a range in Excel, use the 'Create from Selection' tool, ensuring that the 'Top Row' checkbox is selected to use the titles from the top row for the names. The 'Manager' range can then be selected from the Name Box.

Step-by-step explanation:

To create defined names for the range B3:E6 using the Create from Selection command, you would first select the range B3:E6. Then, on the Ribbon, you go to the Formulas tab and click on Create from Selection. In the Create Names from Selection dialog box, you make sure that only the Top Row checkbox is selected since you want to use the titles in the top row as the range names. Once you click OK, Excel will create defined names based on the contents of the top row for each corresponding column in the range. To select the 'Manager' range using the Name Box, you would click on the Name Box at the left of the formula bar, and then select 'Manager' from the dropdown list that appears.