kaplan IT133 Unit 6 Assignment

Assignment Grading Rubric

Course: IT133 Unit: 6 Points: 65

Unit 6 Assignment:

Outcomes addressed in this activity:

Unit Outcomes:

· Create formulas.

· Use functions.

· Design charts.

Course Outcomes:

IT133-3:Create spreadsheets using basic spreadsheet functions.

GEL-2.3:Solve real-world problems using mathematical skills.

Exploring Formulas, Functions, and Charts

Scenario

Note: You use the Spreadsheet you created in Unit 5 to complete this Assignment.

Now that you have all the appropriate budget data added to your workbook, you want to analyze it to determine how much your expenses are each month and year as well as how much you make per year to determine if you are spending too much and where you are spending it.

1. Create a formula or use the AutoSum function to have Excel calculate the total the expense for each month.
2. Create a formula or use the AutoSum function to have Excel compute the Total Annual Income.

1. Create a formula or use the AutoSum function to have Excel calculate the Total Annual Expenses.
2. Create a formula to determine the percentage of income used for each annual expense total.

1. 1. Be sure to format it as a percentage. Place that formula in the column next to the total of each monthly expense. (GEL 2.3)

1. At the bottom of your budget add the following three functions to calculate the following based on the monthly expenses:

1. 1. Min

1. 1. Max
   2. Average
2. In cell A1 add a function to show the current date

1. Rename your worksheet tab to Budget Detail.

Now that you have successfully set up your personal budget, formatted it to look professional, and added some formulas and functions analyze your overall income and expenditures, now you will add a pie chart to visually display your expenses.

Using only your monthly expense labels and your Annual expense totals, create a Pie Chart in a worksheet that will show how you are spending your money.

Copyright Kaplan University

Assignment Grading Rubric

Course: IT133 Unit: 6 Points: 65

8. Highlight the appropriate data and create the pie chart and add that chart to a new worksheet.

a. Highlight the Monthly Expenses (not the title, just the expenses; i.e… electric, water, phone…)

b. Highlight the Annual totals for each expense

9. Insert a 3D Pie Chart from the Insert Tab

a. Ensure you move the chart to a new worksheet.

10. Add Data labels to your Pie Chart

11. Format the data labels

a. Show Category name

b. Show Percentages

c. Show Leader Lines

12. Add a title to your Pie Chart

13. Rename the worksheet tab to Pie Chart.

Directions for Submitting Your Assignment

Complete your Spreadsheet in Microsoft Excel and save as Unit_6_Lastname.xslx and submit it to the Assignment Dropbox for Unit 6.

Review the grading rubric below before beginning this activity.

Assignment 6 grading rubric = 65 points

Copyright Kaplan University

Assignment Grading Rubric

Copyright Kaplan University

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.