Extra Challenge Activity: Create an array that links countries to different regions, such as the following:

EGYPT Africa ALGERIA Africa PAKISTAN Africa IVORY COAST Africa ETHIOPIA Africa COTE D'IVOIRE Africa AFRICA Africa NIGERIA Africa GHANA Africa CHAD Africa MAURITANIA Africa MOROCCO Africa MADAGASCAR Africa DJIBOUTI Africa MAURITANIA Africa COMORO IS. Africa GABON Africa LIBYA Africa ALGERIA Africa MOZAMBIQUE Africa TANZANIA Africa BURKINA FASO Africa ANGOLA Africa ERITREA Africa ASCENSION ISLAND Africa KENYA Africa GABON Africa BOTSWANA Africa ZAMBIA Africa GUYANA Africa NIGERIA Africa SEYCHELLES Africa ZAIRE Africa MOZAMBIQUE Africa ZIMBABWE Africa CAMEROON Africa SOMALIA Africa GAMBIA Africa BURUNDI Africa MALI Africa MALAWI Africa GUINEA BISSAU Africa CONGO Africa RWANDA Africa SENEGAL Africa LIBERIA Africa MALAWI Africa SIERRA LEONE Africa INDONESIA Asia CHINA Asia SRI LANKA Asia INDIA Asia JAPAN Asia INDONESIA Asia KAZAKHSTAN Asia MYANMAR Asia LAOS Asia TURKMENISTAN Asia MONGOLIA Asia UZBEKISTAN Asia PHILIPPINES Asia THAILAND Asia NEPAL Asia MALAYSIA Asia VIETNAM Asia BANGLADESH Asia KOREA Asia SOUTH KOREA Asia SRI LANKA Asia TAIWAN Asia HONG KONG Asia MALDIVES Asia NEW ZEALAND Australia AUSTRALIA Australia COCOS-KEELING Australia TASMANIA Australia JAMAICA Caribbean KITTS Caribbean BERMUDA Caribbean INDIES Caribbean BAHAMAS Caribbean LUCIA Caribbean ARUBA Caribbean BARBADOS Caribbean ANTILLES Caribbean CUBA Caribbean CAPE VERDE Caribbean WINDWARD IS Caribbean DOMINICAN Caribbean B.W.I. Caribbean EL SALVADOR Central America HONDURAS Central America PANAMA Central America COSTA RICA Central America BELIZE Central America NICARAGUA Central America HAITI Central America GUATEMALA Central America GERMANY Europe DENMARK Europe FINLAND Europe SCOTLAND Europe UK Europe U.K. Europe CANARY IS. Europe SWITZERLAND Europe TURKEY Europe ETHIOPIA Europe NORWAY Europe ICELAND Europe SWEDEN Europe FRANCE Europe AZORES Spain SPAIN Europe GREENCE Europe ITALY Europe ANDORRA Europe NETHERLANDS Europe BELGIUM Europe ROMANIA Europe GUADELOUPE Europe BUCHAREST Europe SERBIA Europe CROATIA Europe PORTUGAL Europe CZECH REPUBLIC Europe HUNGARY Europe BOSNIA Europe BULGARIA Europe IRELAND Europe POLAND Europe MOLDOVA Europe GREENLAND Europe MONTENEGRO Europe MALTA Europe REYKJAVIK Europe LUXEMBOURG Europe YUGOSLAVIA Europe CANADA North America EDMONTON Canada MEXICO North America MX Mexico CAN North America SANTA CRUZ HUATULCO North America KIRIBATI Pacific NEW GUINEA Pacific SAMOA Pacific PACIFIC Pacific SOLOMON ISLANDS Pacific MARSHALL ISLAND Pacific POLYNESIA Pacific FIJI Pacific MARQUESAS Pacific VANUATU Pacific POLYNESIA Pacific RUSSIA Russia BRA. South America BRAZIL South America VENEZUELA South America SURINAM South America COLOMBIA South America ARGENTINA South America PARAGUAY South America PERU South America CHILE South America BOLIVIA South America ECUADOR South America ARG South America URUGUAY South America USA USA EMIRATES Western Asia KUWAIT Western Asia QATAR Western Asia YEMEN Western Asia IRAN Western Asia JORDAN Western Asia Arabia Western Asia SYRIA Western Asia BAHRAIN Western Asia AZERBAIJAN Western Asia ISRAEL Western Asia IRAQ Western Asia OMAN Western Asia CYPRUS Western Asia

Use a LOOKUP function, such as: =LOOKUP(10^10,SEARCH($F$2:$F$170,B2),$G$2:$G$170) Here, the yellow highlight is the first column (i.e., EGYPT) and the green highlight is the second column (i.e., AFRICA). B2 represents the first cell to lookup and will be the first value in the Airport Codes spreadsheet (i.e., AL ARISH, ARAB REP. OF EGYPT). Copy this formula in a new column for every row in the spreadsheet to link the Airport Code and the Location to the Region. The challenge is to determine, using pivot tables, the top 4 regions for departures by Delta Air Lines, Inc., American Airlines, and United Airlines, combined