Data ~ E From lable Get & Transform Data Queries & Connections Data Types Al X V fx I am buying 50 pounds of candy. Some of the candy sells for $10 per po B G H I am buying 50 pound: of candy. Some of the candy sells for $10 per pound, the other for $6 per pound. 2 How much candy at each price should I buy to arrive at an average cost of $7 per pound. 3 Use Goal Seek to solve. 4 max points 10 6 Total pounds 50 7 Candy 1 per pound $10.00 8 Candy 1 ordered O *this will be the cell you want changed 9 Candy 2 per pound $6.00 10 Candy 2 ordered 50 11 Goal per pound $7.00 12 Total $ amount $300.00 14 *Hint, what Total $ amount will be needed for it to equal $7/pound 27 Q2 Q3 04 05 Ready 5 Accessibility: Investigate Type here to search\f\f\f