1 S 5 7 3 9 0 1 2 13 14 15 16 17 18 19 20 Project ID Location Employee Sales ID 1776 1489 1526 1620 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 2672 2156 1056 1713 1218 2877 1516 1702 2583 1805 1830 2939 1974 1964 1099 2220 1350 2261 1223 1869 1251 2109 2032 1308 2072 1726 2299 2300 2379 2999 1394 1251 1853 2099 Sheet1 Sales Project Details Cost of Sales Project Cost GM + Instruction 1-Use the vlookup function to search for the Location and Employee Sales ID 2-Use the Sumif function to calculation the Sales & total cost of sales under Project details 3-After completing Exercise 1 and 2, create a pivot table showing the Project ID and Employee sales ID under rows, Location under colum, and total amount of Sales, Cost of Sales, and GM under values. Good Luck

intruction Goodivet intruction Goodivet