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

 

 

The Name Manager

A Named Range is a selection of cells that you can define and name with the Name Box. Each of these Defined Names can be found in the Name Manager.

 

1. Try This: Work With Defined Names

Go to Formulas ->Defined Names.

Select Name Manager.

 

graphic2

 

What Do You See? The Name Manager will display all of the Defined Names in this Spreadsheet.

 

Keep going...


Formulas ->Defined Names-> Name Manager

graphic1