For this assignment, you will create a budget and chart analysis for a fictitious business. Its purpose is for you to learn best practices for utilizing spreadsheet software (e.g., Excel, Google Spreadsheets, etc.). The final product will consist of two parts: a budget and a chart.
Excel Activity
Excel Formulas (Excel Activity Walk Through)
Review the tutorials within the Productivity Software module item (presented earlier in the course).
Workbook Requirements
Save your workbook in .xslx or .xls format.
Spreadsheet Budget Analysis and Chart Parameters:
The budget must detail at least four expenses (rent, utilities, etc.) and show income (sales, etc.) for at least four months. Display on a single sheet.
Each expense and month should be appropriately labeled.
The spreadsheet must use at least four different functions/ formulas (to total, add, subtract, divide, etc.)
Must have a total column and total row for expenses and income. Use a function here with cell ranges.
Must have a row that has a formula showing net income after expenses. Use a formula here.
Include cells that show the average and also maximum total monthly expenses. Must use a function for these.
Include an appropriate chart showing only net income for each month.