Question: DO YOU HAVE A MAIL I COULD SEND IT TO ITS AN EXCEL FILE Section One Excel File to Use: Adv_excel.xlsx Adv_excel is a list
DO YOU HAVE A MAIL I COULD SEND IT TO ITS AN EXCEL FILE
Section One Excel File to Use: Adv_excel.xlsx Adv_excel is a list of the 334 Members of Parliament for Canada (last parliament). Using Excel and WITHOUT THE USE OF PIVOT TABLES. you are to: Make yourself the 335th MP, assign whatever affiliation you want, make up a constituency, province, etc. Make a copy of the data into another worksheet, you'll want it for later. Sum by party affiliation, store results in a new table (separate worksheet, if necessary), create a chart with this data. Using the list provided, colour code each MP's affiliation based upon his party colour: Liberals - Red Conservatives - Dark blue NDP - Orange Green - Green Bloc Quebecois - Light blue Independent - Your choice People's Party - supposed to be blue but let's go with Yellow With Ontario only, count the MPs in the province by party affiliation in a new table (separate worksheet, if necessary), create a chart with this data. Use party colours in the chart. Enhance this chart to highlight the number of NDP MPs in the province. Using the copy of the data that you made at the start, make the data into a table, sort by constituency name and filter to show Alberta only Section One Excel File to Use: Adv_excel.xlsx Adv_excel is a list of the 334 Members of Parliament for Canada (last parliament). Using Excel and WITHOUT THE USE OF PIVOT TABLES. you are to: Make yourself the 335th MP, assign whatever affiliation you want, make up a constituency, province, etc. Make a copy of the data into another worksheet, you'll want it for later. Sum by party affiliation, store results in a new table (separate worksheet, if necessary), create a chart with this data. Using the list provided, colour code each MP's affiliation based upon his party colour: Liberals - Red Conservatives - Dark blue NDP - Orange Green - Green Bloc Quebecois - Light blue Independent - Your choice People's Party - supposed to be blue but let's go with Yellow With Ontario only, count the MPs in the province by party affiliation in a new table (separate worksheet, if necessary), create a chart with this data. Use party colours in the chart. Enhance this chart to highlight the number of NDP MPs in the province. Using the copy of the data that you made at the start, make the data into a table, sort by constituency name and filter to show Alberta only
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
