AutoSave OFF SUE : Problem Set 01 - Home Insert Draw Page Layout Formulas Data Review View Tell me X V Arial 11 A ab ce General Paste BI U av A. E F E $ v % , 4 .00 >0 Condition Formattir B2 x fx A B B D E F G H T J L M N 0 P Q The data table shows employee ID codes, salaries, and years of experience. Use VLOOKUP function Write a formula that takes a given ID code and yields the employee's salary. Write another formula that takes a given ID code and yields the employee's years of experience. ID Code Salary 7406159 Experience 1 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 ID CODE Salary 45856827 $188,272 29099936 $55,663 4639128 $50,895 72647981 $171,541 94270333 $178,939 49505709 $85,323 11741046 $190,165 21281615 $88,839 20143706 $69,328 44631675 $150,854 43380927 $120,902 59654577 $114,149 84765908 $90,555 5620154 $123,553 7406159 $194,059 47927178 $84,381 8838256 $86,975 12696373 $68,813 3644626 $51,565 5544349 $156,446 62909768 $135, 109 54317026 $140,871 64162206 $170,032 54636987 $61,359 6529727 $190,464 40407549 $172,230 57816494 $195,399 32776673 $187,702 14239910 $196,843 62867501 $121,211 39212594 $149,368 22050032 $71,602 66841312 $138,800 66395645 $89,334 89464298 $131,260 48968487 $140,354 35629192 $194,357 29110262 $160,458 6053307 $85,391 61435949 $112,828 79801882 $163,027 53429314 $120,803 Experience 30 31 29 34 10 15 11 15 39 10 24 4 31 33 25 16 19 40 27 27 29 20 10 8 14 31 28 32 28 26 8 2 4 0 25 1 28 7 21 25 9 20 41 42 43 44 45 46 47 Q1. Craps Q2. HR Checkup Q3.Distances Q4. ToysRU Q5. Makeup-IFS +