Remember that good data is needed for valid information. Valid information is needed to make knowledgeable decisions. How can we leverage the power of Excel to make better decisions? The Goal Seek function is an extremely useful tool that allows us to set a goal (for example an increase in profit) and determine ways to achieve the goal. For more detail see: https://www.linkedin.com/learning/excel-2016-essential-training/using-goal-seek?u=76811570Links to an external site.
Returning to the Ester’s Sweet Shop, please create three new worksheets using the workbook below that answers the following questions:
What is the percentage increase in the sales of jelly beans to increase total sales to $190,000.00?
What is the new price of mints to increase total sales to $190,000.00?
What is the increase in pounds of candy sold for Easter to increase total sales to $190,000.00?
