6 Identify the square footage, base price, and total cost in
8.000 the data table that comes closest to their goal. Apply Blue, Accent 1, Lighter 40 % fill color to those cells.
7 Copy and paste the square footage substitution values
12.000 in Table 1 to the range H6: H15. Remove the fill color. Enter these lot price substitution values in the range I5: K5: 90000, 96000, and 102675, respectively. Format these values with the Accounting Number Format with zero decimal places and Blue font.
8 Enter the reference to the total estimated cost in the
12.000 appropriate location for the second data table. Apply a custom number format to display Total Sq Ft in that cell. Apply Blue font and bold to that cell.
9 Complete the second data table using the appropriate
10.000 input cells. Apply Blue, Accent 1, Lighter 40 % fill color to the total price in each column that comes closest to their goal.