Page 115 - Excel Workbook for Dummies

11_798452 ch06.qxp 3/13/06 7:48 PM Page 98
98 Part II: Using Formulas and Functions

11. Choose Window➪New Window to create a new window in the workbook named
Exercise6-4.xls:2, then choose Window➪Exercise6-4.xls:1 to make the first
window active. Finally, choose Window➪Compare Side by Side with Exercise6-4.
xls:2 to display both the Exercise6-4.xls:1 and the Exercise6-4.xls:2 window
together on the screen, one on top of the other.

12. Click the 2006 Spring Sale sheet tab in the Exercise6-4.xls:1 window on the top to
make the sheet with the Sale Table active in the top window and then change the
magnification display percentage to 115% in the workbook.
Note that both the 2006 Spring Sale worksheet in the top window (Exercise6-4.
xls:1) and the Range Names sheet in the lower window (Exercise6-4.xls:2) are
affected equally by the zoom command. Also notice the appearance of the
Compare Side by Side floating toolbar with its Close Side by Side button.
(Your computer screen should now look like the one shown in Figure 6-3.)
Now, you’re ready to apply the range names listed in the Range Name Listing on
the Range Names sheet to the formulas you constructed and copied in the Sale
Table in the 2006 Spring Sale worksheet.
13. Select the cell range with the formulas, D3:E7 in the Sale Table on the 2006 Spring
Sale worksheet, and then choose Insert➪Name➪Apply to open the Apply Names
dialog box.

This dialog box contains a list with all the range names you’ve defined in the
workbook selected.
14. Select the Options button to expand the Apply Names dialog box, and then dese-
lect the Omit Column Name If Same Column and the Omit Row Name If Same
Name check boxes and select OK.
When these check boxes are selected, Excel does not bother to repeat row and
column range names in the formulas. As a result, the formulas copied down the
rows and across the columns of a table all end up with the same descriptions
(which pretty much defeats the purpose of displaying them in the formulas in
the first place).
15. Click the Close Side by Side button in the Compare Side by Side toolbar to
close the second window and return to a full-screen view of 2006 Spring Sale
worksheet.
16. Examine the use of the range names created from the row and column headings
in all the formulas in the cell range D3:E7.
Note that the operand of each formula now includes both the row and the
column range name (separated by a space that represents the Intersection
operator) created from the cell’s row and column heading. For example, the
subtraction formula in cell E6 now reads:
=Buffet Retail_Price-Buffet Discount

This identifies the formula as subtracting the value in the cell at the inter-
section of the Buffet row and Discount column range names from the value in
the cell at the intersection of the Buffet row and Retail_Price column range
names.
17. Select cell A1 and then save your changes to this workbook with the filename
Solved6-4.xls in your Chapter 6 folder inside the My Practice Spreadsheets
folder, and then close both windows on the workbook.