2.Copy the information from the ‘source’ tab to the ‘expenses’ tab. When you copy the data you will learn the relationship between codes & labels. The table also contains dollar values associated with the labels. Put these data in blocks reflecting the categories shown on the ‘summary’ tab (look at the ‘example summary’ tab first). Format the copied information in a pleasing manner resembling the example of the first block at the top of the ‘expenses’ tab. Calculate subtotals for blocks, using the ‘subtotal’ function which should be shown at the bottom of each block as with the example. The subtotal function is explained in Appendix C, in the section on spreadsheeting for budgets.
3.Carry the totals to the ‘summary’ tab using the ‘=’ sign as practiced on the ‘tutorial’ tab. Format the ‘summary’ tab in a pleasing manner. Calculate sums as indicated by the ‘total’ labels on the ‘summary’ tab using the ‘subtotal’ function. Validate success by finding that the ‘self check’ column on the ‘summary’ tab had turned completely ‘TRUE’.