Question: 1) Include a column for Income and another column for Expenses. You can include any items you wish for each of the columns but you
1) Include a column for Income and another column for Expenses. You can include any items you wish for each of the columns but you need to have a minimum of 5 income and 5 expense items.
2) Give a sum for each of the column
3) Conclude with value for the Net Profit formula where:
Net Profit = Income Expenses.
Your spreadsheet is not just a document with numbers entered into the cells. It must include all appropriate formulas and/or relationships.
- The sum for each of the columns (Income & Expenses) must be calculated by formulas.
- The Net Profit value must also be from a formula.
- It should also contain a chart that visually presents your data with a caption that explains the chart.
Refer to your notes from the Excel classroom tutorial.
Grades will be based on presentation and organization of the information as well as the presence of cell relationships.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
