Microsoft Office Tutorials and References
In Depth Information
Using the Name Menu to Create Names
FIGURE 4.6 Use the Name
Data
Instead of B1:E5000
FIGURE 4.7 Using the Range Name
Data
in Formulas
Afterward, it is possible to use the name for the range to obtain the calculations
mentioned above. See Figure 4.6. I did not have to select B1:E5000 or type B1:E5000.
I just typed in the word Data.
I used the function f x
icon to calculate all the other functions. (You may also use
Shift
F3 to get to the Function menu.) See the result in Figure 4.7.
As I explained earlier, it is much easier to handle and understand functions when
they read
þ
¼
SUM(QuarterOneSales) than
¼
SUM(B7:B18). It is more meaningful
when you calculate a formula to read
¼
Jan09 Sales-Dec08 Sales than
¼
C7-C6.
USING THE NAME MENU TO CREATE NAMES
In the following example, I will use the Excel menu to create names. In the sheet
Name Menus of Chapter 4
s workbook, I would like to create names for the different
ranges. See Figure 4.8. In this example, I will call the range C3:C8 Sales, D3:D8 Cost,
and the range E3:E8 Profit.
The other ranges will also be named. C3:E3 will be named Jan, C4:E4 will be
named Feb, C5:C6 will be named Mar, and so on.
The header in row 2 and the information in column B will be used to create the
range names. As you select the range B2:E8, go to the Formulas ribbon and click on
Create from Selection. See Figure 4.9.
 
Search JabSto ::




Custom Search