find answers

CHAPTER 8 Your task in this chapter's Excel problem is to create formulas that will calculate the missing data. Please note that each row has its own individual set of relationships; you will need to figure out the correct formula and cell references for each missing figure. Whatever food this is, doesn't matter! As Purchased Price per Yield Edible Portion Edible Portion Price Quantity Unit Factor Size Cost Factor 1. 20 kg $3.00 85% 200 g /kg 2. 10 kg $15.89 500 g 1.3333 /kg 3. 15 lbs $ 35 80% 4 oz /b 4. $ 7 70% 8 oz $5.00 5 . 2 kg $15 $3.75 1.25 /kg 6. 1 litre $27 90% 100 ml Deliverable: One worksheet in which this table is reproduced, with all 12 missing figures shown in bolded Bernard MT Condensed font