Exam 77-420 Microsoft Excel 2013
4. Apply Formulas and Functions
4.1 Apply Cell Ranges and References in Formulas and Functions:  Use References (Relative, Mixed, Absolute
)

graphic1
 
graphic3
graphic2

Formulas -> Defined Names->Define Name

Name a Range

So far so good. The goal is to select a RANGE of cells and then name it. The example on this page shows how to create a Defined Name with the Formula Ribbon.

 

3. Try This: Name a Range

The spreadsheet is still open to the Original Data. Cells E1:E70 are selected

Go to Formulas->Defined Names.

Click on Define Name.

 

What Do You See? You will be prompted to enter a Name. By default, Microsoft Excel chose the label from Cell E1.

 

What Else Do You See? The New Name Refers to: ='Original Data'!$E$1:$E$70

 

All good formulas begin with equals: =

 

'Original Data' is the name of the sheet.

 

The Range of Cells, $E$1:$E$70 is defined with Absolute Cell References.

Click
OK. Keep going...