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.

Transactions Term Date Description Category Payment Method Amount 04/28/2017 Enrollment Confirmation Deposit Tuition Parents $ 150.00 04/28/2017 Housing Deposit 05/16/2017 MDPT 05/16/2017 Orientation Registration 08/04/2017 CPP Gear Housing Books/Supplies/Fees Parents Books/Supplies/Fees Parents Books/Supplies/Fees Personal Parents $ 450.00 $ 8.00 $ 189.00 $ 61.02 09/19/2017 Housing Deposit Housing Personal $ 150.00 09/20/2017 Tuition Tuition Parents $ 2,297.67 09/20/2017 Housing 09/23/2017 iClicker 09/26/2017 Arts Package Fall 2017 09/27/2017 Gilgamesh 09/27/2017 EGR Paper 09/27/2017 Studying Engineering 09/27/2017 The Distance Between Us Housing Books/Supplies/Fees Personal Books/Supplies/Fees Personal Books/Supplies/Fees Personal Books/Supplies/Fees Personal Books/Supplies/Fees Personal Books/Supplies/Fees Personal Personal $ 3,905.00 $ 25.13 $ 49.00 $ 7.51 $ 10 11.99 10 $ 9.99 $ 9.00 10/03/2017 10/08/2017 CE 122 Manual Pearson's MyLab Books/Supplies/Fees Personal $ 7.43 Books/Supplies/Fees Personal $ 103.95 10/17/2017 Joggers Club Scholarship Scholarships $ 500.00 10/18/2017 Expo Markers Books/Supplies/Fees Personal $ 5.58 10/19/2017 Scantrons Books/Supplies/Fees Personal $ 3.87 10/25/2017 Bowling Scholarship Scholarships $ 27.54 10/28/2017 11/30/2017 CPP Folder Report Cover Books/Supplies/Fees Personal Books/Supplies/Fees Personal $ 1.08 $ 10 1.48