Entering the table data

Now that the table is formatted, you can begin to enter your table data. For the purpose of this tutorial, you will acquire 1.25 days of vacation for each month worked (for a total of 15 vacation days a year).

To enter the table data

1. In cell B2, type the value 0.
2. In each of cells C2 to C13, type the value 1.25.
3. In each of cells D2 to D13, type the value 0.
4. Select cells D2 to D13.
5. Click Format menu Selection properties.
6. Click the Fill/Pattern tab.
7. Open the Pattern color picker, and click a light color.
8. Click OK.
   The cells requiring input after the table is complete are highlighted.

Continue