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

 

Exam 77-882: Microsoft Excel 2010 Core

5. Applying Formulas and Functions

5.6. Apply cell ranges in formulas: Use the Name Manager