assign the range names b9 (base), b15 (interior), b21 (exterior), b23 (lot).

Grader - Instructions Excel 2019 ProjectExp19_Excel_Ch06_ML1_Housing_CostProject Description:Your friends, Elijah and Valerie Foglesong, want to build their dream house. They ident

assign the range names b9 (base), b15 (interior), b21 (exterior), b23 (lot).

Grader - Instructions Excel 2019 ProjectExp19_Excel_Ch06_ML1_Housing_CostProject Description:Your friends, Elijah and Valerie Foglesong, want to build their dream house. They identified tentative costs, but they cannotafford the $414,717 estimated cost. You will use Goal Seek to determine an estimate of the total finished square footage theycan afford. To help provide more flexibility in their decision-making, you will create a data table listing various finished squarefootages and their effects on the base house cost and total cost. Finally, you will create another data table showingcombinations of square footages and lot prices to identify total costs.Steps to Perform:Step Instructions PointsPossible1Start Excel. Download and open the file namedExp19_Excel_Ch06_ML1_HW-Housing Cost.xlsx. Grader hasautomatically added your last name to the beginning of the filename.02Assign the range names B9 (Base), B15 (Interior), B21 (Exterior),B23 (Lot).43Enter a formula in cell B25 to calculate the total estimated cost. Thetotal estimated cost is the sum of the base house price (B9), totalinterior upgrades (B15), total exterior upgrades (B21), and lot fee(B23). Be sure to use range names in the formula.54Use Goal Seek to determine the total finished square footage to meetthe total cost goal of $350,000.75Enter a series of total square footage ranging from 1,800 to 3,600 inincrements of 200 in the range D6:D15. Apply Blue font and CommaStyle with zero decimal places to the series.126Enter a reference to the base house price in cell E5 and a reference tothe total estimated cost in cell F5.77Complete the single variable data table in the range D5:F15. Be sureto use total square footage as the column input. Apply Custom numberformats to give appropriate descriptions to the second and thirdcolumns. Apply these formats to the headings: bold, center, and Bluefont color.128Identify the square footage, base price, and total cost in the data tablethat comes closest to their goal. Apply Yellow fill color to those cells.69Copy the square footage substitution values, range D6:D15 to therange H6:H15 and remove the fill color. Enter these lot pricesubstitution values in the range I5:K5: 90000, 96000, and 102675.Format these values with Accounting Number Format with zerodecimal places and Blue font color.12Created On: 11/06/2020 1 Exp19_Excel_Ch06_ML1 - Housing Cost 1.4

Video liên quan