Formulas -> Defined Names->Define Name You can
use a Named Range to find and select the data. This is also a good
way to proof your Ranges. Before
You Begin: Go to a blank sheet. Select
Cell A1. 1. Try
This:
Select a Named Range
Go to the down arrow on the Name Box.
Select: Revenue. 2. What Do
You See? You will be taken to the Original Data spreadsheet. The
Revenue Range, Cells E1:E58, should be selected and highlighted.
Exam 77-882: Microsoft Excel 2010
Core
5. Applying Formulas and Functions
5.6. Apply cell ranges in formulas:
Select a Named Range |
|
| |
