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 .