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.

  1. The sum for each of the columns (Income & Expenses) must be calculated by formulas.
  2. The Net Profit value must also be from a formula.
  3. 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!