Question 12 10 pts Download the data analytic data file called "CityFinancialData-1.xlsx" and rename it with your first name and last name. Submit the excel file with your solution. You will analyze the annual account balance information for city departments for six fiscal years. The data file contains data aggregated to the annual level for the different city departments. You will answer the question: how have total department budgets changed each year? To answer the question, please finish the following: 1. Create a PivotTable in a new worksheet that shows the budgeted amount of expenditures for each fiscal year. 2. Include grand totals for column. 3. Add conditional formatting data bars to show which amounts are the greatest, Upload Choose a File Question 12 10 pts Download the data analytic data file called "CityFinancialData-1.xlsx" and rename it with your first name and last name. Submit the excel file with your solution. You will analyze the annual account balance information for city departments for six fiscal years. The data file contains data aggregated to the annual level for the different city departments. You will answer the question: how have total department budgets changed each year? To answer the question, please finish the following: 1. Create a PivotTable in a new worksheet that shows the budgeted amount of expenditures for each fiscal year. 2. Include grand totals for column. 3. Add conditional formatting data bars to show which amounts are the greatest, Upload Choose a File