Spreadsheet: 68570d1269117655-mixed-graphs-assignment-5
Sheet: Directions

Module 2080 Assignment #5
Name:
This Assignment is worth 20% of the Final Mark
Part I, [NAME]. (Questions 1-7 are worth 10% each)
Jump to Part II
Please read the case below carefully and proceed to carry out the 5 steps of the assignment below in completing the worksheet and formatting the results for presentation.
Case:  Your family is making an annual budget for living expenses. With the data provided on the Part I worksheet, complete a spreadsheet to build the budget.
1.  [NAME] the spreadsheet by adding in the functions to total the monthly expenses and revenues, calculate the net income and the annual totals.
2.  Create an Explode Pie Chart of the components of the Total Expenses for whole year. Copy this chart into a MS Word Document, save it and send it in with this assignment to be marked.
3.  Create a Mixed Chart with the Monthly Total Revenues and Expenses depicted as a vertical bar charts and the Monthly Net Income depicted as a line graph with triangles as data markers on the lines.
4. [NAME] your table for printing by inserting manual page breaks so that the table is printed out in quarters, with three months on each page.
5. Customize the Header to include the Date of printing and the Title, Smith Family Monthly Budget. Customize the Footer to include the [NAME] number.
6. Hide the Rows containing the Expenses and Revenues data so that only the totals will be displayed.
7. Hide the columns for the months so that only annual totals are displayed. Copy this table into a MS Word Document, save it and send it in with this assignment to be marked.
Part II, Format the Results of your Worksheet for your project. (worth 30 marks)
Format the results of your worksheet(s) for your project in such a way as to present the results in an effective manner. Send it in with this assignment or paste a copy right on this worksheet.  Of course marks will be awarded based on how well you apply the concepts in this and the last sections in this module to your project.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A pilot is flying a small, single-engine charter plane with a couple of really important execs on board into Seattle airport. There is fog so thick that visibility is only 40 feet, and his instruments are out. He circles, looking for a landmark. After an hour, he is low on fuel and his passengers are very nervous. At last, through a small opening in the fog, he sees a tall building with one guy working alone on the fifth floor.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Circling, the pilot banks and shouts through his open window, "Hi, where am I?"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The solitary office worker replies, "You're in an airplane."
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The pilot executes a swift 275 degree turn and makes a perfect blind landing on the airport's runway five miles away. Just as the plan stops, the engines cough and die from lack of fuel. The stunned passengers are relieved, and ask the pilot how he did it.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Simple, replies the pilot, "I asked the guy in that building a simple question. The answer he gave me was 100% correct, but absolutely useless. Therefore, that must have been the Microsoft Excel support office. I know that, from there, the airport is three minutes away on a heading of 87 degrees."