Designing and implementing a solution

Computer Applications for Business Week 8 AssignmentMS Excel: Budget AnalysisApply your creative thinking and problem-solving skills to design and implement a solution.NOTE:You will need to use file from the textbook for the assignment:Lab 8-3 Budget AnalysisPart 1:The workbook provided shows household income and expenses. You will create charts to help analyze your budget.1.Open the workbook Lab 8-3 Budget Analysis provided and save as CS155Week8LastnameFirstname. Ensure that you useyourlastnameandfirstname.
2.In the budget analysis file change; wages, food, phone, and clothing data for each month. (Leaving these items the same will result in a deduction)
3.Create a chart using the expenses from the budget.
4.Create a second chart using the cash flow data from the budget.
5.The following areas will be part of grading criteria:Changes to data asked for in Part 1Ensure the charts created display months and appropriate items from column ACreate a chart from expenses dataMove expense data chart to own sheetRename new sheet with expense chart to descriptive titleCreate chart title for expense data chartCreate a chart from cash flow dataMove cash flow chart to own sheetRename new sheet with cash flow chart to descriptive titlesCreate chart title for cash flow chartSave the file as CS155Week8LastnameFirstname. Ensure that you use yourlastnameandfirstnameAdd a footer in left section of with your name andGIDnumberNOTE:Charts not required to be pivot charts
Part 2:In Part 1 you made choices about which type(s) of chart(s) to use to present budget data. What was the rationale behind those selections? How did the data in the a special challenge? How might you address that challenge?Answer Part 2 questions in comments or submission text area when submittingSave file after completing and submit work by attaching file to week 8 assignment submission area.Grading Criteria Assignment Maximum PointsChange data in sheet for wages, food, phone and clothing 15Create a chartExpenses dataCash flow data 25Move chart to own sheet (expense and cash flow) 10Rename new sheet to descriptive titles (expense and cash flow) 10Create chart title (expense and cash flow) 10Add footer -in left section putyourname and GID number 10Part 2 Questions answered 10Save the file as CS155Week8LastnameFirstname 10Override for incorrect file type, template used or incorrect content or file used100

Still stressed from student homework?
Get quality assistance from academic writers!
Open chat
1
You can contact our live agent via WhatsApp! Via + 1 9294730077

Feel free to ask questions, clarifications, or discounts available when placing an order.

Order your essay today and save 20% with the discount code HURRAY