How do I make the data table with cell D$8$ because I don't know what to put in for the column row. I just need help with these two questions, I need to be told step by step what to do$.$

$1.$Build one$-$variable data tables.

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

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.$)$

You can use any cell in column D as the input cell.

Figure $9-87$ Data table setup for commission rates

Decrease the decimal two times for all values in the data table.

$2.$ Name cell ranges.

Click the Price Solver worksheet tab.

Click cell C$12$ and name the range Selling$\_$Price. You cannot use spaces in a range name.

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

Install the Solver Add$-$in and the Analysis ToolPak.