Based on the data in Table 16.1, create totals for each funding source while still showing...

Transcribed Image Text:

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

Answer rating: 100% (QA)

The detailed ... View the full answer