2.In the 'Table Area' below, create a table with three headings with the following order: Year, Total Money Earned at Current Job, Total Money Earned at Future Job. (See 'Example | Part 1' tab) 3.In the column under year, start with the number 1 and fill the cells down to 20 years. 4.In the column under "Total Money Earned at Current Job" calculate the total amount of money Cindy will have earned by the end of each of the corresponding years. Do this by writing an equation that multiplies the year by 12 and then by the monthly earnings for that job. (See 'Multiplication' on 'Grading Sheet | Help' tab) Be sure to use a relative reference for the year and an absolute reference for the earnings number. (See 'Cell References' on 'Grading Sheet | Help' tab) Copy the equation down the column for all 20 years.
Assignment Instructions
Below, create a table and graph like the ones in the 'Example | Part 1' tab. Follow the steps below to do this.
2.In the 'Table Area' below, create a table with three headings with the following order: Year, Total Money Earned at Current Job, Total Money Earned at Future Job. (See 'Example | Part 1' tab)
3.In the column under year, start with the number 1 and fill the cells down to 20 years.
4.In the column under "Total Money Earned at Current Job" calculate the total amount of money Cindy will have earned by the end of each of the corresponding years.
- Do this by writing an equation that multiplies the year by 12 and then by the monthly earnings for that job. (See 'Multiplication' on 'Grading Sheet | Help' tab)
- Be sure to use a relative reference for the year and an absolute reference for the earnings number. (See 'Cell References' on 'Grading Sheet | Help' tab)
- Copy the equation down the column for all 20 years.
5.Do the same type of equation for the column under "Total Money Earned at Future Job" but this time use the amount she will earn at the future job.
- Copy the equation down the column for all 20 years
6.Format the cells in the columns labeled "Total Money Earned at Current Job" and "Total Money Earned at Future Job" to currency using the $ symbol. (See 'Format Currency' on 'Grading Sheet | Help' tab)
7.In the 'Graph Area' below, graph the two lines for the total money at the current job and the total money at the future job on one graph. (See 'Graph Lines/Graph Labels' on 'Grading Sheet | Help' tab)
- Do this by highlighting the entire table you just created, including the headings, and then inserting a scatter plot with connected lines graph.
- Add a title to the graph called "Cindy's Projected Earnings".
- Add axis labels to the x and y axes similar to the graph in the 'Example | Part 1' tab.
8.See your score for part 1 by going to the 'Grading Sheet | Help' tab of this spreadsheet file
Once you are done with the 'Part 1' tab of this assignment, start working on 'Part 2 - Cindy's Earnings' tab.
| Cindy's current average monthly earnings $1,984.00 |
| Cindy's average monthly earnings at the job she hopes to get in the future $3,946.18 |
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
