Mark the steps as checked when you complete them.

$$ Open the PlacerHills$-09$ start file. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor. Enable the content security warning.

Review formulas.

a$.$ Select cell C$14$ on the Calculator worksheet. The total commission is calculated by multiplying the selling price by the commission rate.

b$.$ Select cell C$15.$ The IFS function checks the selling price $($C$12)$ to determine the split percentage $($column D$)$ based on the price group.

c$.$ Select cell C$16.$ The IFS function checks the selling price $($C$12)$ to determine the administrative fee percentage $($column E $)$ and multiplies that percentage by the value in cell C $15$ to calculate the fee in dollars.

d$.$ Select cell C$17.$ The net commission is calculated by subtracting the fees from the PHRE amount.

Build one$-$variable data tables.

Select cell C$20$ and create a reference to cell C$15.$

b$.$ Select cell D$20$ and create a reference to cell C$17.$ Both formulas depend on cell C$12,$ the one variable.

Use cell D$8$ as the column input for the data table $($Figure $9-87).($You can use any percentage from column D because its value is replaced by the proposed rates in column B in the data table.$)$

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$.$ Click cell C$12$ and name the range Selling$\_$Price. You cannot use spaces in a range name.

c$.$ Name cell C$14$ as Total$\_$Commission and cell C$17$ as PHRE$\_$Commission.