I need help with the last 3 questions with what formulas to use and how to input them. I keep getting errors as I input which means I am missing something or doing it entirely wrong.
Complete the steps as requested. Complete the steps as requested. 1/13/19 Please enter your formula or cell reference in the wellow cell CUST 040 ANA Plene enter your formula or cell reference in the yellow all CUSTOSS PRODO CUST that this only needs to be done for the original A-K columns from Date to Collections, not any columns you add 3 later.) 2) Use data validation to restrict Values for the entire Date column (excluding the header row, Induding the dataset and all empty rows beyond the dataset). The restriction is values entered have to be less than or equal to whatever 4 the current date is (updating, so that dates which have not occurred yet cannot be entered). 3) Use reference formulas (VLOOKUP, INDEX/MATCH, XLOOKUP) to find the earliest transaction date where CUST- 040 bought from us this year. (Note that by default reference formulas will find and return the fint value listed, so s you will want to make sure to sort your dataset first) 4) Use reference formules and text manipulation formulas to find the only tramaction date where CUST-OSS PROD-028 from us this year. You may use as many columns as you would like to help you solve for the answer 5) Using reference formulas, text manipulation formulas, and any other formulas that we have learned, calculate Shipping Expense for each transaction on the DAZ Data worksheet, per the details below. My advice to split this up into as many steps as possible and concentrate on one at a time. You may use as many columns or other reference Information or tables you create to solve for the answer. To calculate Shipping Expense units 7 multiplied by X]. [Sales divided by 10 TRICULATE TOPTATION DE WESTERITOIMINTA Data worksheet. You will need to calculate Shipping Expense for each row on DAAR Data. Use any of VLOOKUP, XLOOKUP, OF INDEX/MATCH to take that information, look it up on the DAA2 Reference worksheet, and then return a Warehouse Location and a Product Location. Once you have each of these, then take the number at the end of each location designation (le, 2 for Location 21 calculate X by taking the absolute Value difference for example, Location Location 2 gives you 3 and 2 and then the absolute value of 3 minus 21. Then plug X (where in that example, X-1) into the shipping Expense equation (units multiplied by X] + Sales divided by E 201 Complete the steps as requested 10 11 12 1 14 15 16 11 Orice de Tours AG 0 . . 1 A Dale 9900 Gallem Ware 3513 1 SU MAS M. ts 2014 4370 1 COM 1 w VAR MAOS KO 2170 106 1110 // NE PE OVE LEONE oo MOS 1 11/19 CUT. 100 SO MA MAJO USA MSANI M AL LE GO WE US LI 1980 1 11/19 ISOOOW TEPE LE 10 11 w VU ws PELIT 3341 34 TH ON 14 w MATE 1/1/19 19 11/19 NA WIN 15 PE c Sen Pro Malas 10 CUSTOD 140 MAT COD- MALBY CUST 012 PRODOS MAIL CUST RCO013 MATI Men Sh 11 1891 POD MATA SES PCOM MAT 1P20 COM O Manou GOOD GUNTO MATION WIS 19 CU GROSS MAL PEM DU OS US MATLO 1951 CUSTOM 1-033 MATLAR CUSTO WAS SUS 00-05 CUET 12 moon MAIL UT-1960 MATIC GUSTOM MAIL 4 GUSTO MOD-14 WAL W CUET 000 MAT 2 GUSTO ODIN MATL- SUM MAL- CUST sor 3 MO MATIE OUT Don MALT WE GUST.138 MATL MAL CUSTO 25 SOS CUSTOD 10 CUET OD 11 VAL- GUST.145 PRO- MATL WS DUS DOO MALO CST346 MOO- MUS C-346 MOSH MAT MALE was CUSTOM RODI . DAAR ET 1/1/19 1/1/9 MA MA 30 ro WE SEPSE 100 DIR ro TIE w ST DC SULT MA MU 10 ESO 2009 1/1/19 11/29 WEISE MAGE M IT SC a 22 0 17 LET PEM 24 25 20 27 24 * ZS EN 19 D Tv MAT M M MU $20 OM 2224 SET CEO 2224 06 WE 11/19 DEVI 4 LE LE 10 BIVAA 1900 Office Update To keep up-to-date with security updates, fixes, and improvements, ct C41 XV fx PROD-040 A 8 D E F G H 1 Warehouse Location Product Location 25 MSA 24 Location 2 PROD-024 Location: 26 NSA 25 Locations PROD-025 Locations 27 MSA-26 Location1 PROD-026 Locations 28 MSA-27 Location PROD-027 Locations 29 MSA 28 Locations PROD-028 Location 2 30 MSA 29 Location PROD-079 Location 31 MSA-30 Location PROD-030 Locations 32 MSA-31 Locations PROD-031 Location 33 MSA-32 Location PROD-032 Location 34 MSA-33 Locations PROD-033 Location 35 MSA 34 Locations PROD-034 Locations 36 MSAS Locations PROD-035 Location) 32 MSA 36 Location PROD-036 Location: 38 MSAS Location PROD-027 Locations 39 MISA 38 Location PROD-038 Locations 40 MSA-39 Locations PROO-039 Location 41 MSA-40 Locations PROD 040 Location MSA-43 Location PROD-041 Location 43 MSA 42 Locations PROD-042 Location 44 MSA 43 Location PROO-043 Location 45 MSA 44 Location 2 PROD-046 Location: MSA 45 Locations PROD-045 Location 47 MSA 46 Locations PROD-046 Location 48 VISA-47 Locations PROD-047 Locations MESA 40 Location PROD048 Location 50 MSA-49 Location 2 PROD-049 Loc04 51 MSA SO Locations 7800-050 Locations 52 MSAS: Loco PRODOS Locations MISAS Location PROD 052 Location 54 WAS3 Location PROD-053 Locat SS MSA 54 Locations PROD 054 Location 156 MSA-SS Locations PROO-055 Location MAS Location PROD-056 Locations MISA 57 Location PROD-057 Location VISA SE Locations PROD 055 Location 10 59 Locations PRODOS Location MAGO Location 2 PRODOGO Locations WSA61 Location PROD 061 Locations MSA62 Location PROD-062 Locations MSA 63 Locations PRO 063 Location M 064 1 > DAA2 Instructions DAA2 Questions DAA2 Data DAAR Refere 52 3 Complete the steps as requested. Complete the steps as requested. 1/13/19 Please enter your formula or cell reference in the wellow cell CUST 040 ANA Plene enter your formula or cell reference in the yellow all CUSTOSS PRODO CUST that this only needs to be done for the original A-K columns from Date to Collections, not any columns you add 3 later.) 2) Use data validation to restrict Values for the entire Date column (excluding the header row, Induding the dataset and all empty rows beyond the dataset). The restriction is values entered have to be less than or equal to whatever 4 the current date is (updating, so that dates which have not occurred yet cannot be entered). 3) Use reference formulas (VLOOKUP, INDEX/MATCH, XLOOKUP) to find the earliest transaction date where CUST- 040 bought from us this year. (Note that by default reference formulas will find and return the fint value listed, so s you will want to make sure to sort your dataset first) 4) Use reference formules and text manipulation formulas to find the only tramaction date where CUST-OSS PROD-028 from us this year. You may use as many columns as you would like to help you solve for the answer 5) Using reference formulas, text manipulation formulas, and any other formulas that we have learned, calculate Shipping Expense for each transaction on the DAZ Data worksheet, per the details below. My advice to split this up into as many steps as possible and concentrate on one at a time. You may use as many columns or other reference Information or tables you create to solve for the answer. To calculate Shipping Expense units 7 multiplied by X]. [Sales divided by 10 TRICULATE TOPTATION DE WESTERITOIMINTA Data worksheet. You will need to calculate Shipping Expense for each row on DAAR Data. Use any of VLOOKUP, XLOOKUP, OF INDEX/MATCH to take that information, look it up on the DAA2 Reference worksheet, and then return a Warehouse Location and a Product Location. Once you have each of these, then take the number at the end of each location designation (le, 2 for Location 21 calculate X by taking the absolute Value difference for example, Location Location 2 gives you 3 and 2 and then the absolute value of 3 minus 21. Then plug X (where in that example, X-1) into the shipping Expense equation (units multiplied by X] + Sales divided by E 201 Complete the steps as requested 10 11 12 1 14 15 16 11 Orice de Tours AG 0 . . 1 A Dale 9900 Gallem Ware 3513 1 SU MAS M. ts 2014 4370 1 COM 1 w VAR MAOS KO 2170 106 1110 // NE PE OVE LEONE oo MOS 1 11/19 CUT. 100 SO MA MAJO USA MSANI M AL LE GO WE US LI 1980 1 11/19 ISOOOW TEPE LE 10 11 w VU ws PELIT 3341 34 TH ON 14 w MATE 1/1/19 19 11/19 NA WIN 15 PE c Sen Pro Malas 10 CUSTOD 140 MAT COD- MALBY CUST 012 PRODOS MAIL CUST RCO013 MATI Men Sh 11 1891 POD MATA SES PCOM MAT 1P20 COM O Manou GOOD GUNTO MATION WIS 19 CU GROSS MAL PEM DU OS US MATLO 1951 CUSTOM 1-033 MATLAR CUSTO WAS SUS 00-05 CUET 12 moon MAIL UT-1960 MATIC GUSTOM MAIL 4 GUSTO MOD-14 WAL W CUET 000 MAT 2 GUSTO ODIN MATL- SUM MAL- CUST sor 3 MO MATIE OUT Don MALT WE GUST.138 MATL MAL CUSTO 25 SOS CUSTOD 10 CUET OD 11 VAL- GUST.145 PRO- MATL WS DUS DOO MALO CST346 MOO- MUS C-346 MOSH MAT MALE was CUSTOM RODI . DAAR ET 1/1/19 1/1/9 MA MA 30 ro WE SEPSE 100 DIR ro TIE w ST DC SULT MA MU 10 ESO 2009 1/1/19 11/29 WEISE MAGE M IT SC a 22 0 17 LET PEM 24 25 20 27 24 * ZS EN 19 D Tv MAT M M MU $20 OM 2224 SET CEO 2224 06 WE 11/19 DEVI 4 LE LE 10 BIVAA 1900 Office Update To keep up-to-date with security updates, fixes, and improvements, ct C41 XV fx PROD-040 A 8 D E F G H 1 Warehouse Location Product Location 25 MSA 24 Location 2 PROD-024 Location: 26 NSA 25 Locations PROD-025 Locations 27 MSA-26 Location1 PROD-026 Locations 28 MSA-27 Location PROD-027 Locations 29 MSA 28 Locations PROD-028 Location 2 30 MSA 29 Location PROD-079 Location 31 MSA-30 Location PROD-030 Locations 32 MSA-31 Locations PROD-031 Location 33 MSA-32 Location PROD-032 Location 34 MSA-33 Locations PROD-033 Location 35 MSA 34 Locations PROD-034 Locations 36 MSAS Locations PROD-035 Location) 32 MSA 36 Location PROD-036 Location: 38 MSAS Location PROD-027 Locations 39 MISA 38 Location PROD-038 Locations 40 MSA-39 Locations PROO-039 Location 41 MSA-40 Locations PROD 040 Location MSA-43 Location PROD-041 Location 43 MSA 42 Locations PROD-042 Location 44 MSA 43 Location PROO-043 Location 45 MSA 44 Location 2 PROD-046 Location: MSA 45 Locations PROD-045 Location 47 MSA 46 Locations PROD-046 Location 48 VISA-47 Locations PROD-047 Locations MESA 40 Location PROD048 Location 50 MSA-49 Location 2 PROD-049 Loc04 51 MSA SO Locations 7800-050 Locations 52 MSAS: Loco PRODOS Locations MISAS Location PROD 052 Location 54 WAS3 Location PROD-053 Locat SS MSA 54 Locations PROD 054 Location 156 MSA-SS Locations PROO-055 Location MAS Location PROD-056 Locations MISA 57 Location PROD-057 Location VISA SE Locations PROD 055 Location 10 59 Locations PRODOS Location MAGO Location 2 PRODOGO Locations WSA61 Location PROD 061 Locations MSA62 Location PROD-062 Locations MSA 63 Locations PRO 063 Location M 064 1 > DAA2 Instructions DAA2 Questions DAA2 Data DAAR Refere 52 3
