I need to know what the formulas look like for steps 1-6..

Home Insert Draw Page Layout Formulas Data Review View TI D 3. Connections El Properties B Edit Links 21 7 clear 4 Flash Fill El Flash Ful Clear Reapply Advanced Stocks Le From HTML l From Text New Database Query B12 x Geography Refresh All 4. Sort Filter ' Text to Columns Remove fx A B C D 1. (1 point) Create a dropdown list for the Order ID in A12 using Data Validation. 2. (1 point) Write a formula with the VLOOKUP function in B12 to return Customer Name matching the selected Order ID from the dropdown list in A12. 3. (1 point) Write a formula with the VLOOKUP function in C12 to return ship Date matching the selected Order ID from the dropdown list in A12. 4. (1 point) Enable filtering on Ship Date so that orders can be filtered by Ship Date. 5. (1 point) Write a formula in the cell D12 to return the number of customers located in West (Hints: review COUNTIF and COUNTIFS functions) 6. (1 point) Write a VLOOKUP in J15 to show "First Class" if Region is East, "Second Class" if West, "Standard Class" if Central, "Priority" if South. Order Lookup Customer Name Ship Date Number of Customers in West Select Order ID 12 Order ID 13 14 Order ID 15 CA-2016-152156 16 CA-2016-152156 17 CA-2016-138688 18 US-2015-108966 19 US-2015-108966 20 CA-2014-115812 21 CA-2014-115812 22 CA-2014-115812 23 CA-2014-115812 24 CA-2014-115812 25 CA-2014-115812 26 CA-2014-115812 27 CA-2017-114412 28 CA-2016-161389 29 US-2015-118983 30 US-2015-118983 Order Date Ship Date Customer ID Customer Name 11/8/16 11/11/16 CG-12520 Claire Gute 11/8/16 11/11/16 CG-12520 Claire Gute 6/12/166/16/16 DV-13045 Darrin Van Huff 10/11/15 10/18/15 SO-20335 Sean O'Donnell 10/11/15 10/18/15 SO-20335 Sean O'Donnell 6/9/146/14/14 BH-11710 Brosina Hoffman 6/9/146 /14/14 BH-11710 Brosina Hoffman 6/9/146/14/14 BH-11710 Brosina Hoffman 6/9/146 /14/14 BH-11710 Brosina Hoffman 6/9/146/14/14 BH-11710 Brosina Hoffman 6/9/146 /14/14 BH-11710 Brosina Hoffman 6/9/146 /14/14 BH-11710 Brosina Hoffman 4/15/17 4/20/17 AA-10480 Andrew Allen 12/5/16 12/10/16 IM-15070 Irene Maddox 11/22/15 11/26/15 HP-14815 Harold Pawlan 11/22/15 11/26/15 HP-14815 Harold Pawlan City State Postal Code Region Ship Mode Henderson Kentucky 42420 South Henderson Kentucky 42420 South Los Angeles California 90036 West Fort Lauderdale Florida 33311 South Fort Lauderdale Florida 33311 South Los Angeles California 90032 West Los Angeles California 90032 West Los Angeles California 90032 West Los Angeles California 90032 West Los Angeles California 90032 West Los Angeles California 90032 West Los Angeles California 90032 West Concord North Carolina 28027 South Seattle Washington 98103 West Fort Worth Texas 76106 Central Fort Worth Texas 76106 Central Home Insert Draw Page Layout Formulas Data Review View TI D 3. Connections El Properties B Edit Links 21 7 clear 4 Flash Fill El Flash Ful Clear Reapply Advanced Stocks Le From HTML l From Text New Database Query B12 x Geography Refresh All 4. Sort Filter ' Text to Columns Remove fx A B C D 1. (1 point) Create a dropdown list for the Order ID in A12 using Data Validation. 2. (1 point) Write a formula with the VLOOKUP function in B12 to return Customer Name matching the selected Order ID from the dropdown list in A12. 3. (1 point) Write a formula with the VLOOKUP function in C12 to return ship Date matching the selected Order ID from the dropdown list in A12. 4. (1 point) Enable filtering on Ship Date so that orders can be filtered by Ship Date. 5. (1 point) Write a formula in the cell D12 to return the number of customers located in West (Hints: review COUNTIF and COUNTIFS functions) 6. (1 point) Write a VLOOKUP in J15 to show "First Class" if Region is East, "Second Class" if West, "Standard Class" if Central, "Priority" if South. Order Lookup Customer Name Ship Date Number of Customers in West Select Order ID 12 Order ID 13 14 Order ID 15 CA-2016-152156 16 CA-2016-152156 17 CA-2016-138688 18 US-2015-108966 19 US-2015-108966 20 CA-2014-115812 21 CA-2014-115812 22 CA-2014-115812 23 CA-2014-115812 24 CA-2014-115812 25 CA-2014-115812 26 CA-2014-115812 27 CA-2017-114412 28 CA-2016-161389 29 US-2015-118983 30 US-2015-118983 Order Date Ship Date Customer ID Customer Name 11/8/16 11/11/16 CG-12520 Claire Gute 11/8/16 11/11/16 CG-12520 Claire Gute 6/12/166/16/16 DV-13045 Darrin Van Huff 10/11/15 10/18/15 SO-20335 Sean O'Donnell 10/11/15 10/18/15 SO-20335 Sean O'Donnell 6/9/146/14/14 BH-11710 Brosina Hoffman 6/9/146 /14/14 BH-11710 Brosina Hoffman 6/9/146/14/14 BH-11710 Brosina Hoffman 6/9/146 /14/14 BH-11710 Brosina Hoffman 6/9/146/14/14 BH-11710 Brosina Hoffman 6/9/146 /14/14 BH-11710 Brosina Hoffman 6/9/146 /14/14 BH-11710 Brosina Hoffman 4/15/17 4/20/17 AA-10480 Andrew Allen 12/5/16 12/10/16 IM-15070 Irene Maddox 11/22/15 11/26/15 HP-14815 Harold Pawlan 11/22/15 11/26/15 HP-14815 Harold Pawlan City State Postal Code Region Ship Mode Henderson Kentucky 42420 South Henderson Kentucky 42420 South Los Angeles California 90036 West Fort Lauderdale Florida 33311 South Fort Lauderdale Florida 33311 South Los Angeles California 90032 West Los Angeles California 90032 West Los Angeles California 90032 West Los Angeles California 90032 West Los Angeles California 90032 West Los Angeles California 90032 West Los Angeles California 90032 West Concord North Carolina 28027 South Seattle Washington 98103 West Fort Worth Texas 76106 Central Fort Worth Texas 76106 Central