Excel Questions:
On the “Cities” worksheet, create a chart that displays the “Population” for eavh city as a column and the “Rank” as a Line with markers. When creating the chart, give it a secondary axis for the “Rank”.
Give the newly made chart the title “Population & Rank”.
Move the newly made chart to a new sheet called “Population & Rank”.
On the “Cities” worksheet, create a Funnel chart that displays the population data for the cities listed in cells F2:F12 with the descriptions to the left of the chart. Change the chart title to “Population”. The chart size and position do not matter.
On the “Pop Growth” worksheet, in cells D4:D13, enter formulas that return the population data for each city listed from cells B4:B13. Use named ranges in your function.
On the “Pop Growth” worksheet, use Fill Series feature to complete the population projections using a linear growth rate based on each city’s yearly projected population change.
On the “Cities” worksheet, change the data validation error message for cells D4:D13 to “Please enter correct data”.
Configure Excel to Disable all macros in the workbook without notifications.
Configure Excel so that you can edit content using Albanian as the editing language. Do not make Alnanian the default editing language. If you are prompted to restart Office, dismiss the prompt but do not restart Excel.
Require that users enter the password “123” before they can make structural changes to the workbook.
On the “Cities” worksheet, use error-checking features to locate the formula that is inconsistent with those around it. Correct the error.
Use the data from the “Pop Growth” sheet to create a PivotTable on a new sheet. Name the sheet “Population Change”
In your new PivotTable, apply the “City” field as your rows and “Present” & “2030” data as your value fields so we can compare the two data sets.
In your PivotTable, create a calculated field named “Change” that displays the population change from “Present” to “2030”.
In the PivotTable, add a filter to only include data from the top 5 populations (based on the 2030 values).
With your filtered PivotTable, insert a slicer that allows you to filter the PivotTable by “City”. Move the slicer directly to the right of your PivotTable.
Based on the PivotTable, create a Combo PivotChart that shows the “Present” and “2030” fields as clustered columns and the “Change” field as an area. Make sure you include a secondary axis so the “Change” is visible.
Using the slicer you created earlier, only show Beijing, Tokyo, New Delhi, Moscow, and Mexico City’s data.
Change the slicer style to Light Green Slicer Style Dark 6.
Change the Combo PivotChart color to Monochromatic Palette 6.
Change the PivotTable style to be Light Green Style Light 7 and add banded rows if they were not already included.
On the “Top 15 Cities” sheet, switch the value field to “Rank” instead of “Population”
Sort the PivotTable from lowest to highest value of rank (1 being the lowest value)
With your sorted PivotTable, insert a slicer that allows you to filter the PivotTable by “Country”. Move the slicer directly to the right of your PivotTable.
Create a clustered bar chart based on the PivotTable data. Change the chart title to “Ranking By City”.
Using your slicer, filter so that all information is showing in your PivotTable and Bar Chart except data from Armenia and Austria.
Change the slicer style to Light Yellow Slicer Style Light 4.
Change the Bar Chart color palatte to Monochromatic Palette 4.
Change the Bar Chart style to style 12.
Protect the “Top 15 Cities” worksheet by adding the password “1234”.
