Use Goal Seek to determine the total finished square footage to meet the total cost goal of $350,000.

Enter a series of total square footages ranging from 1,800 to 3,600 in increments of 200 in the range D6:D15. Apply Blue font and Comma Style with zero decimal places to the series.

Enter a reference to the base house price in cell E5 and a reference to the total estimated cost in cell F5.

Complete the data table using the appropriate input cell. Apply custom number formats to display Base Cost in cell E5 and Total Cost in cell F5. Apply Blue font, bold, and center formats to these headings.

Identify the square footage, base price, and total cost in the data table that comes closest to their goal. Apply Blue, Accent 1, Lighter 40% fill color to those cells.

Copy and paste the square footage substitution values 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.

Enter the reference to the total estimated cost in the 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.

Complete the second data table using the appropriate input cells. Apply Blue, Accent 1, Lighter 40% fill color to the total price in each column that comes closest to their goal.

Format results in both tables with Accounting Number Format with zero decimal places.

Answer rating: 100% (QA)

Consider the following excel sheet for the question Use Goal Seek to determine the total finished square footage to meet the total cost goal of 350000 Click WhatIf Analysis in the Data Tools group und... View the full answer