Please help with all parts. Thank you

A B C D E F G Red Bluff Golf Course & Pro Shop Forecast of Product Sales 3 Goal Seek is another scenario tool that maximizes Excel's cell-referencing capabilities and enables you to find the input values needed to achieve a goal or objective. Goal Seek can be used to determine the number of boxes of golf balls and high-performance golf polo shirts Red Bluff needs to sell to meet its sales goals as well as the selling price of golf shorts and golf umbrellas required to meet its sales goals. On the Salestorecast worksheet, use Goal Seek to determine the quantity of stock golf balls needed to sell in order to meet the sales goal (extended price) of $27,500. Format cell C5 as a Number with 0 decimal places. Use Goal Seek to determine the selling price required for golf shorts to meet the sales goal (extended price) of $14,000. Use Goal Seek to determine selling price of large golf umbrellas to meet the sales goal (extended price) of $7,500. Use Goal Seek to determine the quantity of high nerformance golf polos needed to sell in order to meet the sales goal (extended price) of $20,100. Use the Format Painter to copy the formatting from cell C5 and apply the formatting to cells C6:C8. A B C D E F G Red Bluff Golf Course & Pro Shop Forecast of Product Sales 3 Goal Seek is another scenario tool that maximizes Excel's cell-referencing capabilities and enables you to find the input values needed to achieve a goal or objective. Goal Seek can be used to determine the number of boxes of golf balls and high-performance golf polo shirts Red Bluff needs to sell to meet its sales goals as well as the selling price of golf shorts and golf umbrellas required to meet its sales goals. On the Salestorecast worksheet, use Goal Seek to determine the quantity of stock golf balls needed to sell in order to meet the sales goal (extended price) of $27,500. Format cell C5 as a Number with 0 decimal places. Use Goal Seek to determine the selling price required for golf shorts to meet the sales goal (extended price) of $14,000. Use Goal Seek to determine selling price of large golf umbrellas to meet the sales goal (extended price) of $7,500. Use Goal Seek to determine the quantity of high nerformance golf polos needed to sell in order to meet the sales goal (extended price) of $20,100. Use the Format Painter to copy the formatting from cell C5 and apply the formatting to cells C6:C8