Question: 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:

Based on the data in Table 16.1, create totals for each funding

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.) TABLE 16.1 Departments, Expenditures, and Funding Sources Department Expenditure ($)Funding Fund Administration35,320,649 Special Source FundingAdministration388,553,192CapitalAttorney71,441,747 General FundAttorney22,287,191Special Source Funding Corrections42,410,651 General FundCorrections40,613,139Special Source FundingCourts77,109,840 General FundCourts17,093,360Special Source Funding Education2,260,912 Special Source Funding Education62,328,934General Fund Transportation106,871,908 Special Source FundingTransportation82,089,011 Capital Troopers86,584,089 General Fund Troopers211,573,117 Special Source Funding SourceAdministration51,860,554General

Step by Step Solution

3.47 Rating (157 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

The detailed ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!