Excel Spreadsheet

1: Analyzing Quarterly Expenses

Academic

To estimate the funds needed by your school’s travel club to make it through the upcoming quarter, you decide to create a report for the club itemizing the expected quarterly expenses. The anticipated expenses are listed in the numbers below. 1. Create a spreadsheet. 2. Insert the data in table form as mentioned.. 3. Create an embedded chart using data in the table you have created. 4. Total each expense item and each quarter. 5. Include a grand total for all expenses. 6.Using a manual formula, insert the averages with appropriate titles as needed. This is the only excel assignment I will have you perform. Put it in an excel spreadsheet, and upload the file. Data you need are below. 

Travel Club Quarterly Expenses

                              1st Qrtr  2nd Qtr   3rd Qrtr 4th Quarter

Copies and Supplies 75 50 80 150   

Meeting Room Rent 400 425 400 425

Miscellaneous 150 100 175         70

Refreshments 130 155 150       225

Speaker Fees 200 200 400       500

Travel             450      375       500       375