Exam 77-420 Microsoft Excel 2013
2. Create Cells and Ranges
2.1 Insert Data in Cells and Ranges: Create Named Ranges

graphic2
graphic1

Name That Tune

In Excel, you can name a cell, or a range of cells. Using names makes it easy to go to a particular place. It also simplifies cell references when you create equations.

 

3. Try it: Name the Range

Select Cells F1 through G5.

Go to Formula->Defined Names.

Select Define Name.

 

What Do You See? The New Name screen will pop up. The Name, Sales, came from the label in Cell F1.

 

Refers to: Show the name of the spreadsheet, Bonus. The Range of data can be found in cell F1 through G5.

 

Click OK and continue...

graphic3

Formula -> Defined Names->Define Names