4.
Try it: Create a Named Range Select the
RANGE G1:K2. Go to
Formulas->Defined Names. Click on
Define Name. What Do
You See? Microsoft Excel will prompt you to enter the following
information: Name:
Terms Refers
to: =Customers!$G$1:$K$2 Keep
going...!
Memo to
Self: The Scope means this Defined Name is available to
every sheet in this Excel workbook. You can limit the scope to one
specific worksheet if you wish.
Formulas->Defined Names->Define Name
Exam 77-882: Microsoft Excel 2010
Core
5. Applying Formulas and Functions
5.5. Apply named ranges in formulas
|
|
| |
