Exam 77-882: Microsoft Excel 2010
Core
5. Applying Formulas and Functions
5.6. Apply cell ranges in formulas:
Use the Name Manager
Formulas ->Defined Names->Name Manager The
Name Manager simplifies the task of finding and editing the
Defined Names in an Excel workbook. You can
use the Name Manager to create, edit and delete Defined Names. 2. Try It:
Review the Defined Names Go to
Formulas->Defined Names. Click
on Name Manager. Select a
Name: QuantitySold What Do
You See? This Defined Name Refers to the Original Data sheet. This is an
Absolute Reference to Cells $D$1 through
$D$58. Keep
going... |
|
| |
