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.




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


Keep going...

Formulas ->Defined Names-> Name Manager