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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started