⦁ Create a new blank spreadsheet ⦁ Save the document as Lab 6.0 ⦁ Merge and center cells A1: I1 ⦁ In cell A1 Type: CIT 105 Lab 6.0 ⦁ Make the following changes to CIT 105 Lab 6.0 ⦁ Bold CIT 105 Lab 6.0 ⦁ Change the font size to 16 ⦁ Change the font color to red ⦁ Merge and center cells A2:I2 ⦁ Make the following changes to A2 ⦁ Type EARNINGS in cell A2 ⦁ Bold EARNINGS ⦁ In A3 type: Occupation ⦁ In B3 type: Median Pay ⦁ In F3 type: Income ⦁ In I3 type: After Taxes ⦁ In A4 type the name of the occupation you hope to obtain (HINT: use the one you researched on Occupation Outlook Handbook) (Data Analyst) ⦁ In B4 enter the median pay for that occupation on the Occupation Outlook Handbook ⦁ In F4 enter: Yearly Pay ⦁ In F5 enter: Monthly Pay ⦁ In F6 enter: 2-WK Pay ⦁ In F7 enter: 1-WK Pay ⦁ In F8 enter: Daily Pay ⦁ In F9 enter: Hourly Pay ⦁ Merge and center A11:I11 ⦁ In A11 enter: Budget ⦁ Bold Budget ⦁ In A12:A21 create the list below: (The one that starts with rent) ⦁ In B12:B21 enter the amounts for each items (you can look these up online or use real amounts if you know them. You can look up average rent, average food bill, and so on) ⦁ In E12 enter: Monthly Earnings ⦁ In E13 enter: Monthly Bills ⦁ In E14 enter: SAVINGS ⦁ Bold savings and change the font color to red ⦁ In B4 enter the medial pay for your occupation ⦁ In G4 enter the formula: =B4 (this copies the amount in B4 to this cell) ⦁ In G5 enter: = G4/12 (this is how much you earn each month) ⦁ In G6 enter: =G4/26 (this is how much you earn every 2 weeks) ⦁ In G7 enter: =G4/52 (this is how much you earn each week) ⦁ In G8 enter: =G4/260 (this is how much you earn each day. 5 days a week * 52 weeks) ⦁ In G9 enter: =G4/2080 (this is how much you earn each hour, 8 hours a day, 5 days a week, 52 weeks a year, 8*5*52=2080) ⦁ In I4 enter: =G4*.7 (this is how much you take home after taxes, social security, and such, taxes take up about 30% of your income. So, 100-30 = 70, 70%, or .7) ⦁ Grab the autofill handle in I4 and pull it down to I9 (you will now see the take home amounts for each period after taxes) ⦁ Click INSERT from the toolbar ⦁ Select A12:B21 ⦁ Pick 3-D Pie from the chart menu ⦁ Change the Chart Title to: Your Name’s Budget ⦁ Place the top left corner of the chart in cell D18 ⦁ Save your work and submit the document Should look like png attached "board"
⦁ Create a new blank spreadsheet
⦁ Save the document as Lab 6.0
⦁ Merge and center cells A1: I1
⦁ In cell A1 Type: CIT 105 Lab 6.0
⦁ Make the following changes to CIT 105 Lab 6.0
⦁ Bold CIT 105 Lab 6.0
⦁ Change the font size to 16
⦁ Change the font color to red
⦁ Merge and center cells A2:I2
⦁ Make the following changes to A2
⦁ Type EARNINGS in cell A2
⦁ Bold EARNINGS
⦁ In A3 type: Occupation
⦁ In B3 type: Median Pay
⦁ In F3 type: Income
⦁ In I3 type: After Taxes
⦁ In A4 type the name of the occupation you hope to obtain (HINT: use the one you researched on Occupation Outlook Handbook)
(Data Analyst)
⦁ In B4 enter the median pay for that occupation on the Occupation Outlook Handbook
⦁ In F4 enter: Yearly Pay
⦁ In F5 enter: Monthly Pay
⦁ In F6 enter: 2-WK Pay
⦁ In F7 enter: 1-WK Pay
⦁ In F8 enter: Daily Pay
⦁ In F9 enter: Hourly Pay
⦁ Merge and center A11:I11
⦁ In A11 enter: Budget
⦁ Bold Budget
⦁ In A12:A21 create the list below: (The one that starts with rent)
⦁ In B12:B21 enter the amounts for each items (you can look these up online or use real amounts if you know them. You can look up average rent, average food bill, and so on)
⦁ In E12 enter: Monthly Earnings
⦁ In E13 enter: Monthly Bills
⦁ In E14 enter: SAVINGS
⦁ Bold savings and change the font color to red
⦁ In B4 enter the medial pay for your occupation
⦁ In G4 enter the formula: =B4 (this copies the amount in B4 to this cell)
⦁ In G5 enter: = G4/12 (this is how much you earn each month)
⦁ In G6 enter: =G4/26 (this is how much you earn every 2 weeks)
⦁ In G7 enter: =G4/52 (this is how much you earn each week)
⦁ In G8 enter: =G4/260 (this is how much you earn each day. 5 days a week * 52 weeks)
⦁ In G9 enter: =G4/2080 (this is how much you earn each hour, 8 hours a day, 5 days a week, 52 weeks a year, 8*5*52=2080)
⦁ In I4 enter: =G4*.7 (this is how much you take home after taxes, social security, and such, taxes take up about 30% of your income. So, 100-30 = 70, 70%, or .7)
⦁ Grab the autofill handle in I4 and pull it down to I9 (you will now see the take home amounts for each period after taxes)
⦁ Click INSERT from the toolbar
⦁ Select A12:B21
⦁ Pick 3-D Pie from the chart menu
⦁ Change the Chart Title to: Your Name’s Budget
⦁ Place the top left corner of the chart in cell D18
⦁ Save your work and submit the document
Should look like png attached "board"
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images
