Exam 77-420 Microsoft Excel 2013
2. Create Cells and Ranges
2.1 Insert Data in Cells and Ranges: Create Named Ranges (The Name Manager)

  
graphic2

Formulas ->Defined Names->Name Manager ->New

graphic1

Edit a Name

Say you wanted to add or modify one of your Names. You can use the Name Manager to edit the name and the range. You can also add a comment to document your changes if you wish.

 

3. Try This: Create or Edit a Name

The Name Manager is still open.
Click on New.
The New Name window will open.

Enter a Name: Product

Enter the Scope: Workbook

Click on Lookup (the red, white and blue button)

 

graphic3

 

Go to the Original Data spreadsheet.

Select Cells B1 through B70.

Click on Lookup to return to the New Name window.
Click on OK to return to the Name Manager.

Keep going...