1 Start Excel. Open exploring _ e06 _ grader _ h2 _ House. xlsx
0.000 and save the workbook asexploring _ e06 _ grader _ h2 _ House _ LastFirst.
2 Use Goal Seek to determine the total finished square 12.000 footage to meet the total cost goal of $ 350,000.
3 Enter a series of total square footages ranging from
12.000
1,800 to3,600 in increments of 200 in the range D6: D15. Apply Blue font and Comma Style with zero decimal places to the series.
4 Enter a reference to the base house price in cell E5 and 12.000 a reference to the total estimated cost in cell F5.
5 Complete the data table using the appropriate input cell.
12.000
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.