les$/$AssessmentTool$/$Presentation$/$AutoGrader$/$AutoGraderPr

gnment on your

gnment Instructions

Use arrow keys to scroll the content

Instructions

Start Excel. Download and open the file named Exp$19\_$Excel$\_$Ch$06\_$ML$1\_$HW$-$Housing Cost.xlsx$.$ Grader has automatically added your last name to the beginning of the filename.

Assign the range names B$9($Base$),$ B$15($Interior$),$ B$21($Exterior$),$ B$23($Lot$).$

Enter a formula in cell B$25$ to calculate the total estimated cost. The total estimated cost is the sum of the base house price $($B$9),$ total interior upgrades $($B$15),$ total exterior upyrades $($B$21),$ and lot fee $($B$23).$ Be sure to use range names in the formula.

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 footage ranging from $1,800$ to $3,600$ in increments of $200$ in the range D$6$:D$15.$ Apply Blue