OVE RVI EW Somerville is a city with a population of almost 80,000 and is one of the most ethnically diverse cities in the country. It is located just two miles north of Boston and occupies just over 4 square miles. Paul Revere rode through the City of Somerville, Massachusetts, during his famous \"Midnight Ride." Its Prospect Hill was where the rst Grand Union ag was raised under orders by General George Washington on January 1, 1776. The City of Somerville, MA, posts its checkbook online for public use. This case uses the City of Somerville (Somerville) checkbook dataset for the years 2013 2016 and contains more than 55,000 records. Note: Even though the City of Somerville, MA, uses a scal year from July 1 through June 30, calendar years are used here so that the analysis does not get complicated from the conversion from scal years to calendar years in Excel pivot tables. RE UIREMENTS For each of the following requirements, create a new pivot table in a new worksheet. Name each new worksheet as \"Req 1,II \"Req 2,\" etc. Format the dollar amounts in each pivot table or pivot chart using the accounting format with zero decimal places. Format non-currency numbers in each pivot table or pivot chart using the accounting format with zero decimal places. 1. From 2013 2016, what was the total spending in each of the four calendar years? 2. In each of the years 2013 - 2016, how much was spent in each of the three categories of government (Education, General Government, and Public Works]? 3. In 2016, which account (use the eld "Account Desc\" for this answer} was the largest in the General Government category? 4. In 2016, who was Somerville's largest vendor as measured by total dollars spent? How many separate payments did the city make to this vendor? What was the average amount of each payment to this vendor? Why did the city pay this vendor? 5. How much in expenditures did Somerville have related to Property, Plant and Equipment (use the eld "Item Class\" for this answer) in the General Government category in each of the years 2013 2016? How much in expenditures in each of those years were related to repairs and maintenance? 6. Prepare a pivot table that shows a line chart of Somerville's expenditures in each of the three categories of government (Education, General Government, and Public Works] for the years 2013 2016. Prepare a pivot chart using the line chart type of this information on the same worksheet. Analyze the pivot chart and summarize the trends