Excel: Sounds Good (Page 1) 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41

 

 

 

 

The Name Game

A Named Range is just a selection of cells that you label with the Name Box. You can use these Defined Names to reference the cells you wanted.

 

Each of the following examples will show formulas that use Named Ranges. Each of the Named Ranges will be stored in the Name Manager.

 

Try This: Work With Defined Names

Go to the Conditional Formatting sheet.

Go to Formulas ->Name Manager.

 

 

What Do You See? The Name Manager will display all of the Defined Names in this Spreadsheet. Keep going...we will add a new Named Range on the next page.


 

Formulas ->Name Manager

  

 

  Microsoft Excel 2007 Exam 77-602 Topic: 3. Creating and Modifying Formulas:  

  3.1. Reference data in formulas  3.1.3. Manage named ranges: Select and name a range of cells