Excel Expense Tracker

You are asked to create a spreadsheet that is useful to you or one of your family members. It must include thes spreadsheet skills:

• AVERAGE function
• Cell Formatting
• Chart
• Count Function
• Max function
• Min Function
• Now Function
• Sum Function
• Worksheet Formatting

Topic is left to your own creativity, you may consider an accounting scenario including budget, proposed cost of redecorating, school costs, transportation cost, Or maybe an inventory of some type of collection with actual cost or value, or some other topic of your own choice.

You must include at least 5 columns and 10 rows of data, Make sure you include an appropriate chart using the data entered with appropriate titles and legend.

Include at least 6 formulas, using the functions listed above.

Deliverables:

In order to satisfactorily complete this case, you should build the worksheet and chart. Create a written presentation that includes:

• A written report discussing any assumption you have made about the case, and the key elements of the case. Explain the purpose of the spreadsheet. List of problems discovered and how your solved them.
• An electronic copy of workbook that includes the spreadsheet and chart
• A printed printout of the worksheet's formulas