1. prepare a complete “Sales” worksheet. 2. compute cost of each material for beginning inventory, all purchases and ending inventory using VLookup. A lookup table appears on the Direct Materials Data worksheet. 3. complete the “Direct Materials Lookup table” using the excel function SUMIFS for Beginning Direct Materials, Purchases and Ending Direct Materials. Use simpleRead more about We can work on Vlookup[…]