Question 1: Download the "Cases.xlsx" and study the dataset given in the U.S.Voters 2012" worksheet. Attempt the following parts. Each part will need a 'separate pivot table. So, either create multiple sheets (one for each part) or create a single sheet having multiple pivot tables. If you opt for the later, don't forget to rename your pivot tables. a) Show States by Total Population. Sort the list by descending order (by Total population) (3 Marks) b) Create a Pivot Chart (Pie Chart) for the last part. (3 Marks) c) Add 'age in the filter, and list data for the '65+' segment. Show the top three states that have the highest Total Population. (3 Marks) d) Remove all the previous filters and create a calculated field called 'Voter Population (Confirmed Voters/Citizen Population) How many states had a Voter Population % greater than 70%? Which states? (3 Marks) e) How many confirmed voters in ALASKA were in the 18-24 bracket? What percentage does that represent out of the total confirmed voters in the US? (3 Marks) Question 1: Download the "Cases.xlsx" and study the dataset given in the U.S.Voters 2012" worksheet. Attempt the following parts. Each part will need a 'separate pivot table. So, either create multiple sheets (one for each part) or create a single sheet having multiple pivot tables. If you opt for the later, don't forget to rename your pivot tables. a) Show States by Total Population. Sort the list by descending order (by Total population) (3 Marks) b) Create a Pivot Chart (Pie Chart) for the last part. (3 Marks) c) Add 'age in the filter, and list data for the '65+' segment. Show the top three states that have the highest Total Population. (3 Marks) d) Remove all the previous filters and create a calculated field called 'Voter Population (Confirmed Voters/Citizen Population) How many states had a Voter Population % greater than 70%? Which states? (3 Marks) e) How many confirmed voters in ALASKA were in the 18-24 bracket? What percentage does that represent out of the total confirmed voters in the US