5. Dynamic Accounting Sheets (Assets and Liabilities)
It seems sometimes that spreadsheets were created specifically for budgeting. They are a highly valued tool for creating balance sheets, cost projections, personal budgets, department budgets and all sorts of other common business forms.
In this final exercise I want you to concentrate on creating an Accounting Sheet (either for yourself or for your business) that lets you balance your own income and expenditures. The numbers should automatically add up to show your net gain/loss.
A well formatted spreadsheet is a thing of beauty, additionally, showing alternatives may also be a valuable asset, either as different worksheets or as different columns in your spreadsheet.
The following are required for full credit in this assignment:
- There must be more than one column and more than one row
- The spreadsheet must be propagated with contact information (even if it's fake)
- It must be evident that the spreadsheet could scale to include many items either by adding more column items or row items (or both)
- File must show experimentation in formatting (font, text style, cell color and cell border).
- File must show mastery of resizing cell sizes (double clicking the line between rows and columns headers, along the top and side of the workspace is the easiest way to accomplish this).
- File must show mastery of linking the cells of different worksheets within one file.
- File must show mastery of the basic formulas available (but must move beyond SUM).