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


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.

OK. Keep going...