Exam 77-882: Microsoft Excel 2010
Core
5. Applying Formulas and Functions
5.5. Apply named ranges in formulas
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->Define 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... Formula ->
Defined Names->Define Names |
|
| |
