Please explain how to do each step other than the ones that are common sense thank you!

a 1. Open the PoolAnd Spa-09 workbook and click the Enable Editing button. The file will be renamed automatically to include your name. . 2. Review formulas a. Select cell D5 on the Forecast worksheet. The text box explains the formula which uses 3D references to the Factors sheet. b.Select cell B12. This is a reference to the growth factor in cell F3 on the Factors sheet. c Click the Factors worksheet tab. The company predicts a general growth rate, but each category's potential is increased or reduced by an adjustment factor. 3. Create scenarios for the growth rate. a. Create a scenario named 15% on the factors sheet for the existing data with cell F3 as the changing cell. b. Add another scenario named .5% and change the value to .005 c. Add scenarios for 1.25% and 1.75% growth rates. In the Scenarios Values dialog box, you must enter the decimal equivalent of the percentage (0125 and 0175). d. Show the 1.25% scenario in the worksheet. e Return to the Forecast worksheet. 4. Build the data table a. Select cell E17. It refers to cell H5.Cells F17 and G17 refer to cells H6 and H7, respectively. b. Use the Fill handle to complete the growth rate percentages in cells D20:D27. c. Select the data table range d. Use cell B12 as the column input cell. The results are incorrect because data table formulas must use data on the same worksheet as the data table 5. Edit formulas to use a reference on the same sheet as the data table. a. Select cell D5, a precedent cell for cell H5. Cells E17.G17 in the data table indirectly refer to (1+Factors/SFS3) in cell D5. b. Edit the formula in cell D5 to show (1+$B$12) in place (1+Factors/$F$3) (Figure 9-96). The data table does not use Factors! SF6 in its calculations, so it need not be changed. c. Copy the formula in cell D5 to the cells E5:65 and (1030$ actors ISTO then to cells D6:G7. The data table updates. d. Redefine the bottom borders of cells as needed. Last Yeart Year Next Year Next To Not You e. Format data table results as Currency with no $325,000111-53512 $307,320 $390,31 341,103 Hat Tuinstallien decimal places Mentenance Contracts $200,000 $272.125 $200,000 $227,40 $100,720 6. Edit a Solver problem to find minimum wages. The de toilettes Previousuartered Growate a. Click the Crew1 worksheet tab. Browth Adjustacto b. Start a Solver problem to find the minimum value for Figure 9-96 Edited formula to refer to cell on the same sheet as the cell E9 by changing cells D5:08. Constraints for cell data table D8 are already entered, c. Add constraints for each of cells D5:07 that reflect the information in column C in the worksheet. . d. Add a constraint that cell D9 be less than or equal to 150. e. Use the GRG Nonlinear solving method (Figure 9-97). 512 c Pool Construction Art 04 01 02 05 04 04 5275,000 $279410380182 443 320D OLD Sestate R. Sehind Sels Ta Oxatue Changing Colt Stathe SCSS 05 SC- SOS SES e. Use the GRG Nonlinear solving method (Figure 9-97). Scherm X Ses Objective SESSI Value OM NO Changing Vrabie Coll SDSS-SDS Add Subject to the Constraints SOSS 45 SC5535 SD5650 SD56 >= 38 SD$48 SOST-40 SD$40 SDSB 32 SD59 = 38 SD$48 SOST-40 SD$40 SDSB 32 SD59