3. Build one-variable data tables. F2 #S a. b. C. d. Decrease the decimal two times for all values in the data table. 4. Name cell ranges. a. Click the Price Solver worksheet tab. b. Select cell C20 and create a reference to cell C15. Select cell D20 and create a reference to cell C17. Both formul Use cell D8 as the column input for the data table (Figure 9-87) because its value is replaced by the proposed rates in column B C. Name cell C14 as Total_Commission and cell C17 as PHRE_Commission. 5.0 Install the Solver Add-in and the Analysis ToolPak. 6. Use Solver to find target PHRE net commission amounts. 9 CO F3 69. Click cell C12 and name the range Selling Price. You cannot use spaces in a range name. F4 Q F5 F6 F7 F8 F9 20 13 15259285 hp N 6 Price Group 7 8 9 10 11 12 11 2 3 PH Place Real E F10 M Selling Pri Commissic Total Comm PHRE Fee Calculas Net Commis Proposed F11