Use Goal Seek to analyze three different sales scenarios. If necessary, open the workbook Lab 3-1 August Online Technology Eight-Year Financial Projection.

1.Divide the window into two panes between rows 6 and 7. Use the scroll bars to show both the top and bottom of the worksheet. Using the numbers in columns 2 and 3 of Table 3-10, analyze the effect of changing the annual sales growth (cell B25) and annual price increase (cell B26) on the net incomes in row 19. Record the answers for each case and submit the results in a form as requested by your instructor.