1. Based on the data in Table 16.1, create totals for each funding source while still showing the departments associated with each funding source. (Hint: Subtotals and/or pivot tables are good tools to help you accomplish this in Excel.)

Departments, Expenditures, and Funding Sources Department Expenditure ($) Funding Source Administration 51,860,554 General Fund Administration 35,320,649 Special Source Funding Administration 388,553,192 Capital Attorney 71,441,747 General Fund Attorney 22,287,191 Special Source Funding Corrections 42,410,651 General Fund Corrections 40,613,139 Special Source Funding Courts 77,109,840 General Fund Courts 17,093,360 Special Source Funding Education 2,260,912 Special Source Funding Education 62,328,934 General Fund Transportation 106,871,908 Special Source Funding Transportation 82,089,011 Capital Troopers 86,584,089 General Fund Troopers 211,573,117 Special Source Funding