Take Quiz Exit Question 13 1 pts What purpose does goal seek achieve in Excel? Find a wille of component in the formula that leads to a target value of the solution O). Find an outcome such that we can change the formila itself O Shift the row and column number somewhere else ) Goal seek achieves all of the above functions Question 14 1 pts One of the firm's suppliers discounts prices for large quantities. The first 1000 parts are for $ 25 each. The next 1000 are for $ 20 each, Anything excess of 2000 units is sold for $ 18 each, The average cost for purchasing 3500 units is O between 18 and 25 O none of the above O > 25 less than 18