|
Excel: Sounds Good
Formulas ->Name Manager The
Name Manager simplifies the task of finding and editing the
Named Ranges in one spreadsheet, or the entire workbook. Try It:
Review the Range Double
click any Name to review the Range. The example on this page shows
that Q1sales can be found on the Worksheet named Conditional
Formulas worksheet, and the Range refers to Cells E1 through
E58. Try It:
Create a New Range Click
New... Go to the
Conditional Formula worksheet, please. |
|||
|
| |||
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