looking for help on Questions 1-3 I have attached each corresponding table.

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.) 156 FOR THE USE OF GRAND CANYON UNIVERSITY STUDENTS AND FACULTY ONLY. NOT FOR DISTRIBUTION, SALE, OR REPRINTING. ANY AND ALL UNAUTHORIZED USE IS STRICTLY PROSLATIVE BUDGET T0OLS Copyright 2015 by SAGE Publications, InEGISI 2. Based on the data in Table 16.2 create totals for each funding source for Departments, Expenditures, and Funding Sources personnel and other-than-personnel expenditures. (Hint: Subtotals and/or Department pivot tables are good tools to help you accomplish this in Excel.) TABLE 16.1 Expenditure ($) Funding Source 51,860,554 35,320,649 388,553,192 71,441,747 22,287,191 42,410,651 40,613,139 77,109,840 17,093,360 2,260,912 62.328,934 106,871,908 82,089,011 86,584,089 211,573,117 General Fund Special Source Funding Capital General Fund Special Source Funding General Fund Special Source Funding General Fund Special Source Funding Special Source Funding General Fund Administration Administration Administration 3. Based on the data in Table 16.3, create a summary graph showing the Attorney Attorney percentage of the total expenditures Corrections associated with each department. Next, Corrections create a graph for the Corrections Courts Department and one for the Troopers Courts Education Education the budgeted expenses associated with Transportation Transportation Troopers 4. Select a current issue for which Troopers Department, showing the proportion of Special Source Funding Capital General Fund each program Special Source TABLE 16.1 Departments, Expenditures, and Funding Sources Expenditure (S) Department Funding Source 51,860,554 35,320,649 388,553,192 71,441,747 22,287,191 42,410,651 40,613,139 77,109,840 17,093,360 2,260,912 62,328,934 106,871,908 82,089,011 86,584,089 211,573,117 General Fund Special Source Funding Capital General Fund Administration Administration Administration Attorney Attorney Corrections Special Source Funding General Fund Corrections Courts Special Source Funding General Fund Courts Special Source Funding Special Source Funding General Fund Special Source Funding Capital General Fund Special Source Education Education Transportation Transportation Troopers Troopers TABLE 16.2 Personnel and Nonpersonnel Funding Sources Amount ($) Type of Expenditure Type of Fund 446,941,184 560,931,401 13,363,748 59,849,210 314,681,043 Special Revenue 452,049,638 Special Revenue 325,577,585 34,759,758 Personnel General Fund Services Capital Services Capital Personnel Services Capital General Fund General Fund Capital Fund Capital Fund Special Revenue TABLE 16.3 Expenditures by Department and Program Expenditure ($) Department and Program Corrections Inmate Substance Abuse Recovery Corrections Inmate Education Corrections Inmate Intake and Release 557,850 339,032 1,674,610 5,982,125 195,475 Corrections Inmate Housing Corrections Information and Communications Technology Troopers Dispatch Troopers Disaster Response Troopers Enforcement Support Troopers Investigations Troopers Patrol Troopers Administration 2,604,257 2,167,148 2,464,721 1,678,722 5,355,280 1,439,370 157