|
Excel: Work Smarter
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.
Try it: Name the
Range
Select cell
F1 through G5.
Go to the
Formula tab Select
Define Name.
Do you see a New Name screen?
The Name, Sales,
came from the label you typed in F1 at the start of this lesson. Refers
to: show the name of the spreadsheet, Bonus. The Range of data
can be found in cell F1 through G5. Formula ->
Name |
|||
|
| |||
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