Microsoft Office Tutorials and References
In Depth Information
Introduction
Figure 1– 1 (b) Pie Chart Showing Monthly Expenses by Category
The rst step in creating an effective worksheet is to make sure you
understand what is required. The person or persons requesting the worksheet
should supply their requirements in a requirements document. A requirements
document includes a needs statement, a source of data, a summary of calculations,
and any other special requirements for the worksheet, such as charting and web
support. Figure 1– 2 shows the requirements document for the new workbook to be
created in this chapter.
Worksheet Title
Personal Budget Worksheet
Needs
A yearly projection of Bob Gleamin’s personal budget
Source of data
The data supplied by Bob Gleamin includes monthly estimates, including
income and expenses
Calculations
The following calculations must be made:
1. For each month, a total for incomes and expenses
2. For each budget item, a total for the item
3. A total for all incomes and expenses
4. Net = income – expenses
Figure 1– 2
EX 3
Search JabSto ::




Custom Search