Part 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 use your lastname and firstname.


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 1

·         Ensure the charts created display months and appropriate items from column A

·         Create a chart from expenses data

·         Move expense data chart to own sheet

·         Rename new sheet with expense chart to descriptive title

·         Create chart title for expense data chart

·         Create a chart from cash flow data

·         Move cash flow chart to own sheet

·         Rename new sheet with cash flow chart to descriptive titles

·         Create chart title for cash flow chart

·         Save the file as CS155Week8LastnameFirstname. Ensure that you use your lastname and firstname

·         Add a footer in left section of sheet named Budget with your name and GIDnumber

NOTE:  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 Household Expenses pose a special challenge? How might you address that challenge?

·         Answer Part 2 questions in comments or submission text area when submitting

Save file after completing and submit work by attaching file to week 8 assignment submission area.

Grading Criteria Assignment

Maximum Points

Change data in sheet for wages, food, phone and clothing

15

Create a chart

·         Expenses data

·         Cash flow data

25

Move chart to own sheet (expense and cash flow)

10

Rename new sheet to descriptive titles (expense and cash flow)

10

Create chart title (expense and cash flow)

10

Add footer -in left section put your name and GID number

10

Part 2 Questions answered

10

Save the file as CS155Week8LastnameFirstname

10

Override for incorrect file type, template used or incorrect content or file used

 

100

 


What Students Are Saying About Us

.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐
"Honestly, I was afraid to send my paper to you, but you proved you are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"

.......... Customer ID: 11***| Rating: ⭐⭐⭐⭐⭐
"This company is the best there is. They saved me so many times, I cannot even keep count. Now I recommend it to all my friends, and none of them have complained about it. The writers here are excellent."


"Order a custom Paper on Similar Assignment at essayfount.com! No Plagiarism! Enjoy 20% Discount!"