Fill out the Final Report sheet so that it looks like the image below. You should use formulas to prepare the final report. Leave the formulas in your solution file for grading. As a hint, you can solve this problem using a combination of the VLOOKUP and CONCATENATE functions. You will need to add columns to some of the sheets to complete the task with these formulas.

What is needed is the formulas on how to automatically fill out FINAL REPORT

CountryCode YearCode CountryName 1 8 Afghanistan 1 9 Afghanistan 1 10 Afghanistan 2 8 Albania 2 9 Albania 2 10 Albania 3 8 Algeria 3 9 Algeria 3 10 Algeria 4 8 Angola 4 9 Angola 4 10 Angola 5 8 Antigua and Barbuda 5 9 Antigua and Barbuda 5 10 Antigua and Barbuda 6 8 Argentina 6 9 Argentina 6 10 Argentina 7 8 Armenia 7 9 Armenia Year Country Name Year 2017 Afghanistan 2017 2018 Afghanistan 2018 2019 Afghanistan 2019 2017 Albania 2017 2018 Albania 2018 2019 Albania 2019 2017 Algeria 2017 2018 Algeria 2018 2019 Algeria 2019 2017 Angola 2017 2018 Angola 2018 2019 Angola 2019 2017 Antigua and Barbuda 2017 2018 Antigua and Barbuda 2018 2019 Antigua and Barbuda 2019 2017 Argentina 2017 2018 Argentina 2018 2019 Argentina 2019 2017 Armenia 2017 2018 Armenia 2018 Ease of doing business score global (DB17-19 methodology) Score-Starting a business 38.94 90.35 37.13 82.55 47.77 92.04 67.1 91.43 69.01 91.49 69.51 91.58 47.61 78.04 47.59 77.86 49.65 78.07 40.32 79.67 41.7 80.09 43.86 80.52 58.43 81.66 59.42 81.69 59.48 81.74 57.86 73.51 57.93 73.55 58.8 81.99 72.44 94.47 73.31 94.47 AutoSave OFF AOC P6-5StartingABusiness Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments E2 1 1 x L M N. P S U A e C C D E F G H 1 CountryCode Year Code Country Name Year Ease of doing business score global (OB17-19 methodology Score Starting a business 2 2 1 & 3 1 1 9 4 4 1 10 5 2 G G 2 7 2 10 8 8 3 9 9 3 10 3 10 11 4 & 12 4 13 4 10 14 5 15 5 16 5 10 17 6 19 6 19 6 10 20 7 2: 7 22 7 10 23 & 24. 3 25 10 26 9 & 27 9 28 9 10 29 10 & 30 10 9 31 10 10 32 11 & 33 11 34 11 10 35 12 & 36 12 37 12 10 38 13 35 13 40 13 10 41 14 & 42 14 9 43 14 10 44 15 45 15 9 46 15 10 47 16 48 15 10 16 Final Report-Advanced Final Report Year Country Doing Business Slarting A Business Ready Dala Description + + 100% AutoSave OFF AO" P6-5StartingaBusiness Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments A1 x fx YearCode 7 3 G H 1 1 K L M N P Q R S T U w X z AA 1 Year Cuceler 2 1 2010 3 2 2011 4 3 2012 5 4 2013 6 S 2014 7 6 2015 8 7 2016 9 2 2017 10 9 2018 11 10 2019 12 13 14 15 16 17 19 19 20 2: 22 23 24. 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 10 Final Report-Advanced Final Report Year Country Doing Business Starting A Business Dala Description + Ready E- + 100% AutoSave OFF AOC P6-5StartingABusiness Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments | c D E F H 1 K L M N 0 Q R S s T U v w X E34 A xv fi B 1 Country Code Country 2 1 Afghanistan 3 2 Albania 4 3 Algeria 5 4 Angala G 5 Antigua and Barbuda 7 Argentina 8 7 Armenia 9 9 3 Australia 10 9 Austria 11 10 Arbaljan 12 11 Bahames, The 13 12 Bahrain 14 13 Bangladesh 15 14 Bangladesh - Chittagong 16 15 Bangladesh - Dhaka 17 15 Barbados 18 17 Belarus 19 18 Belgium 20 19 2: 20 Bain 22 21 Bhutan 23 22 Rolivia 24 23 Bosnia and Herzegovina 25 24 Botswana 26 25 Brasil 27 26 Brazil Rio dejaneiro 28 27 Brazil - Sio Paulo 29 28 Brunei Darussalam 30 29 Bulgaria 31 30 Burkina Faso 32 31 Burundi 33 32 Cabo Verde 34 33 Cambodia 35 34 Cameroon 36 35 Caneca 37 36 Central African Republic 38 37 Chad 39 38 Chile 40 39 Chira 41 40 Chira-Beijing 42 41 Chira Shantal 43 42 Culombia 44 43 Carreras 45 44 Congo, Dem. Rep. 46 45 Congo, Rep. 47 45 Costa Rica 48 10 Final Report-Advanced [] 47 Cte d'Ivoire Final Report Year Country Doing Business Starting A Business Dala Description + Ready E) - + 100% AutoSave OFF AO" P6-5StartingABusiness Share Comments F G H 1 L M M N P R 5 T Yes Home Insert Draw Page Layout Formulas Data Review View Tell me A1 Country A A B c D E 1 Country year Ease of doing business score global (D617-19 methodology) 2 Afghanistan 2017 38.94 3 Albania 2017 67.1 4 Ngeris 2017 47.61 5 Angola 2017 40.32 6 Antigua and Barbuca 2017 52.43 7 Argentina 2017 52.86 8 Annmaria 2017 72.44 9 Australia 2017 80.14 10 Nustria 2017 78.69 11 Azerbaijan 2017 18.04 12 Bahamas, The 2017 56.45 13 Bahrain 2017 68.02 14 Banglade 2017 40.52 15 Bangladest Chittagong 2017 41.48 16 Bangladest-Dhaka 2017 90 29 17 Barbados 2017 56 87 18 Belarus 2017 74.09 19 Belgium 2017 71.94 20 Belize 2017 57.08 21 Benin 2017 49.44 22 Bhutan 2017 65.13 23 Bolivia 2017 49 86 24 Bosnia and Herzegovina 2017 G3.12 25 Botswana 2017 64.82 26 Brazil 2017 56.56 27 Brazil - Rio de Janeiro 2017 57.58 28 Brazil-Sec Paulo 2017 56 01 29 Brunei Darussalam 2017 64.35 30 Bulgaria 2017 71.03 31 Burkina Faso 2017 5124 32 Burundi 2017 46.52 33 Cabo Verde 2017 55.51 34 Cambodia 2017 54.16 35 Cameroon 2017 43.84 36 Canada 2017 72.97 37 Central Mirican Republic 2017 3345 38 Chad 2017 38.58 39 Chile 2017 71.07 40 China 2017 64.47 41 China-Beijing 2017 64.53 42 China Shanghai 2017 G4.42 43 Columbia 2017 69.17 44 Comoros 2017 48 05 45 Congo, Dem. Rep. 2017 3G 46 Congo, Rep 2017 39.99 47 Casta Rica 2017 68.14 42 Cte d'Ivoire 2017 51.05 2017 2002 Final Report-Advanced Final Report Year Country Doing Business Ready Starling A Business Dala Description + # + 100% AutoSave OFF AO" P6-5StartingABusiness Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments A1 Country 7 D E F G H 1 L M N p Q R 5 v W W A A B 1 Country learScoreStarting a business LY 2 Afghanistan 2018 82.55 3 Astianistan 2017 90.35 4 Nighanistan 2019 92.04 5 Albania 2018 91.49 6 Albania 2017 91.43 7 7 Nbania 2015 91 58 & Nigeria 2018 77.85 9 Algeria 2017 78.04 10 Nigeria 2019 7807 11 Angola 2018 80.09 12 Angola 2017 79.57 13 Angola 2015 80 52 14 Antiga and Barbuda 2018 81.59 15 Antigua and Barbuca 2017 81.55 16 Antinand Barbuda 2015 81.74 17 Argentina 2018 7355 18 Argentina 2017 73.51 19 Argentina 2015 81 99 20 Ameria 2018 94.47 21 Armenia 2017 94.47 22 demers 2015 96 21 23 Australia 2018 96 47 24 Australia 2017 96.47 25 Nustralia 2015 9647 26 Austria 2018 83.18 27 Austria 2017 23.1 28 Nustria 2019 83 21 29 Arbaijan 2018 96.11 30 Azerbaijan 2017 96.07 31 Azerbaijan 2019 96 14 32 Bahamas, The 2018 84 18 33 Bahamas, The 2017 82.71 34 Bahamas, The 2019 84.47 35 Bahrain 2018 89 59 36 Bahrain 2017 89.54 2019 89 57 38 Banglade 2018 80.5 39 Bangladet 2017 81.51 40 Bangladest 2019 80 82 41 Bangladedi.Chittagong 2019 80.82 42 Bangladest Chittagong 2018 90.5 43 Bangladesh-Chitture 2017 81 51 44 Bangladesh Dhaka 2019 80.82 45 Bangladesh Dhaka 2018 20.5 46 Bangladest - Dhaka 2017 81 51 47 Barbados 2018 85.11 42 Barbados 2017 25.1 10 Burhus 2016 AS 15 Final Report-Advanced Final Report Year Ready 37 Bahrain Country Doing Business Starting A Business Dala Description + # E- + 100% P6-5StartingABusiness AutoSave FFA OO Home Insert Draw Page Layout Formulas Data Review View A2 * fx Ease of doing business score global (D817-19 methodology) Tell me Share Comments 7 4 C D E F G H. 1 L M 1 Variable Ease of doing business scareglabal (0617-19 methodalogy Definition "Ease of doing business score (DR17-19 methodology!" captures the gap between an economy's performance and a measure of best practice across the entire sample of 41 Indicators for 10 Doing Business topics. The score range from 0 to 100, where represents the worsregulatory performance and 100 the best regulatory performance Calculating the ease of doing business score for each canomy invalves two main steps. In the first step individual component indicators are normalized to a common unit where sich ofthe 4 component indicatorsy (except for the total tax and contribution rate) is rescaled using the lineer transformation (wurst-wurst-best) In this Tonmulation the highest score represents the best regulatary performance on the indicator arass all economie since 2005 or the third year in which data for the indicator were collectes. Both the best regulatory performance and the wors, regulatory performance are established every five years based on the Doing Business cata for the year in which they are established and remain at that love for the five years regardless of any changes in data in interim years. In the second step for calculating the case of doing business score, the scores obtained for individual indicators for each economy are created through simple averaging into one score, first for each tupic and then across all 10 topics. For the mase af daing business score (0817-19 methodologyl.thespecific topic scores used are score Starting a business, Score Dealing with construction permits (0516-19 methodology. Score Getting electricity (0616-19 methodologyl. Scorefregistering property (0B17-19 methodology), Score-Getting credit 0515-19 methodalogy Score Protecting minority inestars (0615-19 methodalogi, Score Paying taxes (D117- 19 methodologyi, Score Trading across borders (0816-19 methodologyi, Score Enforcing contracts (0817-19 . rrethodology), Scorelesslving insolvency (D015-19 methodology 2 Score-Starting a business Score-Starting a businesses the gap between an economy's performance and therey.latory best practice on the Starting a Businex indicator components. It is calculated as the simple average of the scores for "Pracedures (numberl', 'Time (calendar days!",'Cost of income per capital and Psic-in Minimum capital of income per capital. The scores for the following components are obtained as such the score for "Procedures rumberlis calculate based on the average of scarestar' Procedures. Men number and Procedures Women Inumber, the - score for 'Time (calendar days' iscalculated based on the average of scores for 'Time-Men calendar days' and 'Time-Women calendar day and the score for "Cost of income per capital'iscalculated based on the werge o scores tor "Cost - Men (of income per capital and cont Viomen (of income per capital". The score ranges from 0 to 100, where represents the worst regulatory performance and 100 the best regulatory performance. 4 5 6 7 8 9 10 11 12 13 14. 15 16 17 18 19 Final Report-Advanced Final Report Year Country Doing Business Starting A Business Dala Description + Ready + 100% CountryCode YearCode CountryName 1 8 Afghanistan 1 9 Afghanistan 1 10 Afghanistan 2 8 Albania 2 9 Albania 2 10 Albania 3 8 Algeria 3 9 Algeria 3 10 Algeria 4 8 Angola 4 9 Angola 4 10 Angola 5 8 Antigua and Barbuda 5 9 Antigua and Barbuda 5 10 Antigua and Barbuda 6 8 Argentina 6 9 Argentina 6 10 Argentina 7 8 Armenia 7 9 Armenia Year Country Name Year 2017 Afghanistan 2017 2018 Afghanistan 2018 2019 Afghanistan 2019 2017 Albania 2017 2018 Albania 2018 2019 Albania 2019 2017 Algeria 2017 2018 Algeria 2018 2019 Algeria 2019 2017 Angola 2017 2018 Angola 2018 2019 Angola 2019 2017 Antigua and Barbuda 2017 2018 Antigua and Barbuda 2018 2019 Antigua and Barbuda 2019 2017 Argentina 2017 2018 Argentina 2018 2019 Argentina 2019 2017 Armenia 2017 2018 Armenia 2018 Ease of doing business score global (DB17-19 methodology) Score-Starting a business 38.94 90.35 37.13 82.55 47.77 92.04 67.1 91.43 69.01 91.49 69.51 91.58 47.61 78.04 47.59 77.86 49.65 78.07 40.32 79.67 41.7 80.09 43.86 80.52 58.43 81.66 59.42 81.69 59.48 81.74 57.86 73.51 57.93 73.55 58.8 81.99 72.44 94.47 73.31 94.47 AutoSave OFF AOC P6-5StartingABusiness Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments E2 1 1 x L M N. P S U A e C C D E F G H 1 CountryCode Year Code Country Name Year Ease of doing business score global (OB17-19 methodology Score Starting a business 2 2 1 & 3 1 1 9 4 4 1 10 5 2 G G 2 7 2 10 8 8 3 9 9 3 10 3 10 11 4 & 12 4 13 4 10 14 5 15 5 16 5 10 17 6 19 6 19 6 10 20 7 2: 7 22 7 10 23 & 24. 3 25 10 26 9 & 27 9 28 9 10 29 10 & 30 10 9 31 10 10 32 11 & 33 11 34 11 10 35 12 & 36 12 37 12 10 38 13 35 13 40 13 10 41 14 & 42 14 9 43 14 10 44 15 45 15 9 46 15 10 47 16 48 15 10 16 Final Report-Advanced Final Report Year Country Doing Business Slarting A Business Ready Dala Description + + 100% AutoSave OFF AO" P6-5StartingaBusiness Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments A1 x fx YearCode 7 3 G H 1 1 K L M N P Q R S T U w X z AA 1 Year Cuceler 2 1 2010 3 2 2011 4 3 2012 5 4 2013 6 S 2014 7 6 2015 8 7 2016 9 2 2017 10 9 2018 11 10 2019 12 13 14 15 16 17 19 19 20 2: 22 23 24. 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 10 Final Report-Advanced Final Report Year Country Doing Business Starting A Business Dala Description + Ready E- + 100% AutoSave OFF AOC P6-5StartingABusiness Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments | c D E F H 1 K L M N 0 Q R S s T U v w X E34 A xv fi B 1 Country Code Country 2 1 Afghanistan 3 2 Albania 4 3 Algeria 5 4 Angala G 5 Antigua and Barbuda 7 Argentina 8 7 Armenia 9 9 3 Australia 10 9 Austria 11 10 Arbaljan 12 11 Bahames, The 13 12 Bahrain 14 13 Bangladesh 15 14 Bangladesh - Chittagong 16 15 Bangladesh - Dhaka 17 15 Barbados 18 17 Belarus 19 18 Belgium 20 19 2: 20 Bain 22 21 Bhutan 23 22 Rolivia 24 23 Bosnia and Herzegovina 25 24 Botswana 26 25 Brasil 27 26 Brazil Rio dejaneiro 28 27 Brazil - Sio Paulo 29 28 Brunei Darussalam 30 29 Bulgaria 31 30 Burkina Faso 32 31 Burundi 33 32 Cabo Verde 34 33 Cambodia 35 34 Cameroon 36 35 Caneca 37 36 Central African Republic 38 37 Chad 39 38 Chile 40 39 Chira 41 40 Chira-Beijing 42 41 Chira Shantal 43 42 Culombia 44 43 Carreras 45 44 Congo, Dem. Rep. 46 45 Congo, Rep. 47 45 Costa Rica 48 10 Final Report-Advanced [] 47 Cte d'Ivoire Final Report Year Country Doing Business Starting A Business Dala Description + Ready E) - + 100% AutoSave OFF AO" P6-5StartingABusiness Share Comments F G H 1 L M M N P R 5 T Yes Home Insert Draw Page Layout Formulas Data Review View Tell me A1 Country A A B c D E 1 Country year Ease of doing business score global (D617-19 methodology) 2 Afghanistan 2017 38.94 3 Albania 2017 67.1 4 Ngeris 2017 47.61 5 Angola 2017 40.32 6 Antigua and Barbuca 2017 52.43 7 Argentina 2017 52.86 8 Annmaria 2017 72.44 9 Australia 2017 80.14 10 Nustria 2017 78.69 11 Azerbaijan 2017 18.04 12 Bahamas, The 2017 56.45 13 Bahrain 2017 68.02 14 Banglade 2017 40.52 15 Bangladest Chittagong 2017 41.48 16 Bangladest-Dhaka 2017 90 29 17 Barbados 2017 56 87 18 Belarus 2017 74.09 19 Belgium 2017 71.94 20 Belize 2017 57.08 21 Benin 2017 49.44 22 Bhutan 2017 65.13 23 Bolivia 2017 49 86 24 Bosnia and Herzegovina 2017 G3.12 25 Botswana 2017 64.82 26 Brazil 2017 56.56 27 Brazil - Rio de Janeiro 2017 57.58 28 Brazil-Sec Paulo 2017 56 01 29 Brunei Darussalam 2017 64.35 30 Bulgaria 2017 71.03 31 Burkina Faso 2017 5124 32 Burundi 2017 46.52 33 Cabo Verde 2017 55.51 34 Cambodia 2017 54.16 35 Cameroon 2017 43.84 36 Canada 2017 72.97 37 Central Mirican Republic 2017 3345 38 Chad 2017 38.58 39 Chile 2017 71.07 40 China 2017 64.47 41 China-Beijing 2017 64.53 42 China Shanghai 2017 G4.42 43 Columbia 2017 69.17 44 Comoros 2017 48 05 45 Congo, Dem. Rep. 2017 3G 46 Congo, Rep 2017 39.99 47 Casta Rica 2017 68.14 42 Cte d'Ivoire 2017 51.05 2017 2002 Final Report-Advanced Final Report Year Country Doing Business Ready Starling A Business Dala Description + # + 100% AutoSave OFF AO" P6-5StartingABusiness Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments A1 Country 7 D E F G H 1 L M N p Q R 5 v W W A A B 1 Country learScoreStarting a business LY 2 Afghanistan 2018 82.55 3 Astianistan 2017 90.35 4 Nighanistan 2019 92.04 5 Albania 2018 91.49 6 Albania 2017 91.43 7 7 Nbania 2015 91 58 & Nigeria 2018 77.85 9 Algeria 2017 78.04 10 Nigeria 2019 7807 11 Angola 2018 80.09 12 Angola 2017 79.57 13 Angola 2015 80 52 14 Antiga and Barbuda 2018 81.59 15 Antigua and Barbuca 2017 81.55 16 Antinand Barbuda 2015 81.74 17 Argentina 2018 7355 18 Argentina 2017 73.51 19 Argentina 2015 81 99 20 Ameria 2018 94.47 21 Armenia 2017 94.47 22 demers 2015 96 21 23 Australia 2018 96 47 24 Australia 2017 96.47 25 Nustralia 2015 9647 26 Austria 2018 83.18 27 Austria 2017 23.1 28 Nustria 2019 83 21 29 Arbaijan 2018 96.11 30 Azerbaijan 2017 96.07 31 Azerbaijan 2019 96 14 32 Bahamas, The 2018 84 18 33 Bahamas, The 2017 82.71 34 Bahamas, The 2019 84.47 35 Bahrain 2018 89 59 36 Bahrain 2017 89.54 2019 89 57 38 Banglade 2018 80.5 39 Bangladet 2017 81.51 40 Bangladest 2019 80 82 41 Bangladedi.Chittagong 2019 80.82 42 Bangladest Chittagong 2018 90.5 43 Bangladesh-Chitture 2017 81 51 44 Bangladesh Dhaka 2019 80.82 45 Bangladesh Dhaka 2018 20.5 46 Bangladest - Dhaka 2017 81 51 47 Barbados 2018 85.11 42 Barbados 2017 25.1 10 Burhus 2016 AS 15 Final Report-Advanced Final Report Year Ready 37 Bahrain Country Doing Business Starting A Business Dala Description + # E- + 100% P6-5StartingABusiness AutoSave FFA OO Home Insert Draw Page Layout Formulas Data Review View A2 * fx Ease of doing business score global (D817-19 methodology) Tell me Share Comments 7 4 C D E F G H. 1 L M 1 Variable Ease of doing business scareglabal (0617-19 methodalogy Definition "Ease of doing business score (DR17-19 methodology!" captures the gap between an economy's performance and a measure of best practice across the entire sample of 41 Indicators for 10 Doing Business topics. The score range from 0 to 100, where represents the worsregulatory performance and 100 the best regulatory performance Calculating the ease of doing business score for each canomy invalves two main steps. In the first step individual component indicators are normalized to a common unit where sich ofthe 4 component indicatorsy (except for the total tax and contribution rate) is rescaled using the lineer transformation (wurst-wurst-best) In this Tonmulation the highest score represents the best regulatary performance on the indicator arass all economie since 2005 or the third year in which data for the indicator were collectes. Both the best regulatory performance and the wors, regulatory performance are established every five years based on the Doing Business cata for the year in which they are established and remain at that love for the five years regardless of any changes in data in interim years. In the second step for calculating the case of doing business score, the scores obtained for individual indicators for each economy are created through simple averaging into one score, first for each tupic and then across all 10 topics. For the mase af daing business score (0817-19 methodologyl.thespecific topic scores used are score Starting a business, Score Dealing with construction permits (0516-19 methodology. Score Getting electricity (0616-19 methodologyl. Scorefregistering property (0B17-19 methodology), Score-Getting credit 0515-19 methodalogy Score Protecting minority inestars (0615-19 methodalogi, Score Paying taxes (D117- 19 methodologyi, Score Trading across borders (0816-19 methodologyi, Score Enforcing contracts (0817-19 . rrethodology), Scorelesslving insolvency (D015-19 methodology 2 Score-Starting a business Score-Starting a businesses the gap between an economy's performance and therey.latory best practice on the Starting a Businex indicator components. It is calculated as the simple average of the scores for "Pracedures (numberl', 'Time (calendar days!",'Cost of income per capital and Psic-in Minimum capital of income per capital. The scores for the following components are obtained as such the score for "Procedures rumberlis calculate based on the average of scarestar' Procedures. Men number and Procedures Women Inumber, the - score for 'Time (calendar days' iscalculated based on the average of scores for 'Time-Men calendar days' and 'Time-Women calendar day and the score for "Cost of income per capital'iscalculated based on the werge o scores tor "Cost - Men (of income per capital and cont Viomen (of income per capital". The score ranges from 0 to 100, where represents the worst regulatory performance and 100 the best regulatory performance. 4 5 6 7 8 9 10 11 12 13 14. 15 16 17 18 19 Final Report-Advanced Final Report Year Country Doing Business Starting A Business Dala Description + Ready + 100%