CE 2070 COMPUTER PROGRAMMING & NUMERICAL METHODS Exercise #6 - Practice Problem Set Please submit your Excel xlsx file p

[answerhappygod]

Ce 2070 Computer Programming Numerical Methods Exercise 6 Practice Problem Set Please Submit Your Excel Xlsx File P 1 (59.91 KiB) Viewed 10 times

Ce 2070 Computer Programming Numerical Methods Exercise 6 Practice Problem Set Please Submit Your Excel Xlsx File P 2 (79.42 KiB) Viewed 10 times

CE 2070 COMPUTER PROGRAMMING & NUMERICAL METHODS Exercise #6 - Practice Problem Set Please submit your Excel xlsx file produced from the following exercise. The objective of the exercise is to create a college expense sheet that summarizes the expenses provided below. To complete the exercise, the following should be performed. 1. A total summary of expenses. Expenses - Scholarships = Total Cost 2. Create two pie charts that include the total amount of: 1) Charges and 2) Payments. 3. Create two summary tables that include the total amount of: 1) Charges and 2) Payments. 4. The pie charts and summary tables should be categorized based on the form of expense or payment. 5. Review your Excel spreadsheet and ensure that it is clear, organized, and easy to follow.
00 Term Fall 2017 Date 04/28/2017 Payment Method Amount Parents Housing Parents Books/Supplies/Fees Parents Books/Supplies/Fees Parents Books/Supplies/Fees Personal Housing Personal Tuition Tuition Housing Housing Personal iClicker Books/Supplies/Fees Personal Arts Package Books/Supplies/Fees Personal Gilgamesh Books/Supplies/Fees Personal EGR Paper Books/Supplies/Fees Personal 09/27/2017 Studying Engineering Books/Supplies/Fees Personal 09/27/2017 The Distance Between Us Books/Supplies/Fees Personal CE 122 Manual Books/Supplies/Fees Personal Books/Supplies/Fees Personal Scholarships Books/Supplies/Fees Personal Books/Supplies/Fees Personal Scholarships Books/Supplies/Fees Personal Books/Supplies/Fees Personal 04/28/2017 05/16/2017 09/20/2017 09/20/2017 09/23/2017 09/26/2017 05/16/2017 Orientation Registration 08/04/2017 CPP Gear 09/19/2017 Housing Deposit 09/27/2017 09/27/2017 10/03/2017 10/19/2017 Transactions Description 10/28/2017 Enrollment Confirmation 11/30/2017 Deposit Housing Deposit MDPT 10/08/2017 Pearson's MyLab 10/17/2017 Joggers Club Scholarship 10/18/2017 Expo Markers Scantrons 10/25/2017 Bowling Scholarship CPP Folder Report Cover Category Tuition Parents $ S s $ $ $ S s $ S IS S 2,297.67 $ 3,905.00 $ $ S $ $ $ IS $ 150.00 S 450.00 8.00 189.00 61.02 150.00 25.13 49.00 7.51 11.99 9.99 9.00 7.43 103.95 500.00 5.58 3.87 27.54 1.08 1.48