I need explaination in each step. Answer this ques only if you know, don't copy paste.

and why? 22. Global 100 Companies. For this problem we will use the data in the file Global 100 that was referenced in Section 3.4 as an example for creating a treemap. Here we will use these data to create a GIS chart. A portion of the data contained in Global 100 is shown below. Continent Asia Asia Asia Asia Market Value (Billions US $) 141.1 124.2 174.4 215.6 202.0 94.7 135.4 Country China China China China China China China Hong Kong Japan Japan Asia Company Agricultural Bank of China Bank of China China Construction Bank ICBC PetroChina Sinopec-China Petroleum Tencent Holdings China Mobile Softbank Toyota Motor Asia Asia Asia Asia 184.6 91.2 193.5 Asia Use Excel to create a GIS chart that (1) displays the Market Value of companies in different countries as a heat map; (2) allows you to filter the results so that you can choose to add and remove specific continents in your GIS chart; and (3) uses text labels to display which companies are located in each country. To do this you will need to create a 3D Map in Excel. You will then need to click the Change the visualization to Region button, and then add Country to the Location box (and remove Continent from the Location box if it appears there), add Continent to the Filters box and add Market Value (Billions US $) to the Value box. Under Layer Options, you will also need to Customize the Data Card to include Company as a Field for the Custom Tooltip. a. Display the results of the GIS chart for companies in Europe only. Which country in Europe has the highest total Market Value for Global 100 companies in that coun- try? What is the total market value for Global 100 companies in that country? b. Add North America in addition to Europe for continents to be displayed. How does the heat map for Europe change? Why does it change in this way? and why? 22. Global 100 Companies. For this problem we will use the data in the file Global 100 that was referenced in Section 3.4 as an example for creating a treemap. Here we will use these data to create a GIS chart. A portion of the data contained in Global 100 is shown below. Continent Asia Asia Asia Asia Market Value (Billions US $) 141.1 124.2 174.4 215.6 202.0 94.7 135.4 Country China China China China China China China Hong Kong Japan Japan Asia Company Agricultural Bank of China Bank of China China Construction Bank ICBC PetroChina Sinopec-China Petroleum Tencent Holdings China Mobile Softbank Toyota Motor Asia Asia Asia Asia 184.6 91.2 193.5 Asia Use Excel to create a GIS chart that (1) displays the Market Value of companies in different countries as a heat map; (2) allows you to filter the results so that you can choose to add and remove specific continents in your GIS chart; and (3) uses text labels to display which companies are located in each country. To do this you will need to create a 3D Map in Excel. You will then need to click the Change the visualization to Region button, and then add Country to the Location box (and remove Continent from the Location box if it appears there), add Continent to the Filters box and add Market Value (Billions US $) to the Value box. Under Layer Options, you will also need to Customize the Data Card to include Company as a Field for the Custom Tooltip. a. Display the results of the GIS chart for companies in Europe only. Which country in Europe has the highest total Market Value for Global 100 companies in that coun- try? What is the total market value for Global 100 companies in that country? b. Add North America in addition to Europe for continents to be displayed. How does the heat map for Europe change? Why does it change in this way