Datasheet

Adding and Editing Data in a Workbook
25
3. Your sheets should now be in order, beginning with January and ending with March.
4. Click the February Sales tab to make that sheet active. Right-click the tab and choose
Insert.
5. When the Insert dialog box comes up, make sure Worksheet is selected and click OK.
6. You now have a new blank worksheet named Sheet1 inserted to the left of the February
Sales sheet. New worksheets are always added to the left (before) the active sheet.
7. Rename Sheet1 to Yearly Totals and color the tab any color you choose.
8. Right-click the Yearly Totals tab and choose Move Or Copy. When the Move Or Copy dia-
log box appears, click the text that reads “(move to end)” in the list of choices under
Before Sheet. Click OK. Now the Yearly Totals sheet is the last one.
9. With the Yearly Totals sheet active, select Insert  Worksheet. A new Sheet2 is now
added to the left of the Yearly Totals sheet.
10. Rename the new sheet 1st Qtr Sales.
11. Inside the 1st Qtr Sales sheet, select Edit  Move Or Copy Sheet.
12. From the Before Sheet list, choose Yearly Totals and select the Create A Copy option.
Click OK. This places a sheet named “1st Qtr Sales (2)” between the 1st Qtr Sales and
Yearly Sales sheets.
13. Use the methods from steps 8, 11, and 12 to make two more copies of the 1st Qtr Sales
sheet, so you have 1st Qtr Sales (3) and 1st Qtr Sales (4) also inserted before Yearly Sales.
14. Rename the new sheets 2nd Qtr Sales, 3rd Qtr Sales, and 4th Qtr Sales.
15. Using the previous techniques, either create nine new blank sheets or copy any of the
empty quarterly sheets until you have sheets for each month. Then rename the sheets to
reflect the month for which they are intended.
16. Either by dragging or right-clicking and moving, rearrange all your sheets until they are
in this order:
January Sales
February Sales
March Sales
1st Qtr Sales
April Sales
May Sales
EXERCISE 1.12 (continued)
4002book.fm Page 25 Friday, March 24, 2006 11:36 PM