have up to 12 done, could you start at 13

2 Assign the range names B9 (Base), B15 (Interior), B21 (Exterior), B23 (Lot). 4 3 5 Enter a formula in cell B25 to calculate the total estimated cost. The total estimated cost is the sum of the base house price (B9), total interior upgrades (B15), total exterior upgrades (B21), and lot fee (B23). Be sure to use range names in the formula. 4 7 Use Goal Seek to determine the total finished square footage to meet the total cost goal of $350,000. 5 12 Enter a series of total square footage 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. 6 7 Enter a reference to the base house price in cell E5 and a reference to the total estimated cost in cell F5. 7 12 Complete the single variable data table in the range D5:F15. Be sure to use total square footage as the column input. Apply Custom number formats to give appropriate descriptions to the second and third columns. Apply these formats to the headings: bold, center, and Blue font color. 8 6 Identify the square footage, base price, and total cost in the data table that comes closest to their goal. Apply Yellow fill color to those cells. 9 12 Copy the square footage substitution values, range D6:D15 to the range H6:H15 and remove the fill color. Enter these lot price substitution values in the range 15:K5: 90000, 96000, and 102675. Format these values with Accounting Number Format with zero decimal places and Blue font color. 10 9 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. 11 8 Complete the two-variable data table using total square footage as the Column Input and lot price as the Row Input. Apply a Custom number format to the reference to the formula cell. Apply Yellow fill color to the total price in each column that comes closest to their goal. 12 Format results in both tables with Accounting Number Format with zero decimal places. 13 3 Create a scenario named Ideal Costs, using Base price per square foot and Lot fee (use cell references). Enter these values for the scenario: 80, 102,675. Created On: 11/06/2020 Exp19_Excel_Ch06_ML1 - Housing Cost 1.4 Grader - Instructions Excel 2019 Project Step Instructions Points Possible 14 3 Create a scenario named Increased Costs, using Base price per square foot and Lot fee (use cell references). Enter these values for the scenario: 100, 110,000. 15 3 Create a scenario named Low Costs, using Base price per square foot and Lot fee (use cell references). Enter these values for the scenario: 60, 80,000. 16 5 Generate a scenario summary report using the cell references for Price per square foot and Lot Fee. Add the appropriate formatting to the newly created report Home Insert Draw Page Layout Formulas Data Review View Tell me Connections v 19. Connections A1 22 > Y Clear Reapply Advanced $ Flash Flu E Data Validation Text to Remove Duplicates - Consolidate Columns o Oroup Ungroup 3 Subtotal Properties Edit Links Get External Data Data from Picture Refresh All Stocks Currencies 1 Sort Filter What If Analysis H5 fx =B25 A B C D E F H i J K L M N 102,675 270,717 1.800 991 2,791 80.00 223,283 $ $ 1 Proposal for Dream Home 2 Elijah and Valerie Foglesong 3 4 Base House Square footage: Main floor 6 Square footage: Basement 7 Total Square footage 8 Base price per square foot 9 Base house price 10 11 Interior Upgrades 12 Granite countertops 13 Hardwood floors 14 Tile floors: main-floor bathrooms 15 Total interior upgrades 16 17 Exterior Upgrades 18 Complete sprinkler system 19 Fence 20 Energy efficient AC 21 Total exterior upgrades 22 23 Lot 24 Table 1: Square Footage Total Sq Ft Base Price Total Cost 1.800 $ 144,000 $ 270,717 2,000 $ 160,000 $ 286,717 2,200 $ 176,000 $ 302,717 2,400 $ 192,000 $ 318,717 wa 2,600 $ 208,000 $ 334,717 2,800 $ w 224,000 S 350,717 3,000 $ 240,000 $ 366,717 3,200 $ 256,000 $ 382,717 3,400 $ 272,000 $ 398,717 3.600 $ 288,000 $ 414,717 Table 2: Square Footage & Lot Total Sq Ft. $ 90,000 $ 1.00 1,800 $ 258,042 $ 2,000 $ 274,042 $ 2,200 $ 290,042 $ 2,400 $ 306,042 $ 2,600 $ 322,042 $ 2,800 $ 338,042 $ 3,000 $ 354,042 $ 3,200 $ 370,042 $ 3,400 $ 386,042 $ 3,600 $ 402,042 $ 96,000 $ 264,042 $ 280,042 $ 296,042 $ 312,042 S wa 328,042 $ 344,042 $ 360,042 $ 376,042 $ 392,042 $ 408,042 $ 286,717 302,717 318,717 334.717 """ 350,717 366,717 382,717 398,717 414,717 $ $ $ $ 3,000 7,500 3,200 13,700 $ $ $ $ 3,525 2,942 3,875 10,342 $ 102,675 2 Assign the range names B9 (Base), B15 (Interior), B21 (Exterior), B23 (Lot). 4 3 5 Enter a formula in cell B25 to calculate the total estimated cost. The total estimated cost is the sum of the base house price (B9), total interior upgrades (B15), total exterior upgrades (B21), and lot fee (B23). Be sure to use range names in the formula. 4 7 Use Goal Seek to determine the total finished square footage to meet the total cost goal of $350,000. 5 12 Enter a series of total square footage 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. 6 7 Enter a reference to the base house price in cell E5 and a reference to the total estimated cost in cell F5. 7 12 Complete the single variable data table in the range D5:F15. Be sure to use total square footage as the column input. Apply Custom number formats to give appropriate descriptions to the second and third columns. Apply these formats to the headings: bold, center, and Blue font color. 8 6 Identify the square footage, base price, and total cost in the data table that comes closest to their goal. Apply Yellow fill color to those cells. 9 12 Copy the square footage substitution values, range D6:D15 to the range H6:H15 and remove the fill color. Enter these lot price substitution values in the range 15:K5: 90000, 96000, and 102675. Format these values with Accounting Number Format with zero decimal places and Blue font color. 10 9 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. 11 8 Complete the two-variable data table using total square footage as the Column Input and lot price as the Row Input. Apply a Custom number format to the reference to the formula cell. Apply Yellow fill color to the total price in each column that comes closest to their goal. 12 Format results in both tables with Accounting Number Format with zero decimal places. 13 3 Create a scenario named Ideal Costs, using Base price per square foot and Lot fee (use cell references). Enter these values for the scenario: 80, 102,675. Created On: 11/06/2020 Exp19_Excel_Ch06_ML1 - Housing Cost 1.4 Grader - Instructions Excel 2019 Project Step Instructions Points Possible 14 3 Create a scenario named Increased Costs, using Base price per square foot and Lot fee (use cell references). Enter these values for the scenario: 100, 110,000. 15 3 Create a scenario named Low Costs, using Base price per square foot and Lot fee (use cell references). Enter these values for the scenario: 60, 80,000. 16 5 Generate a scenario summary report using the cell references for Price per square foot and Lot Fee. Add the appropriate formatting to the newly created report Home Insert Draw Page Layout Formulas Data Review View Tell me Connections v 19. Connections A1 22 > Y Clear Reapply Advanced $ Flash Flu E Data Validation Text to Remove Duplicates - Consolidate Columns o Oroup Ungroup 3 Subtotal Properties Edit Links Get External Data Data from Picture Refresh All Stocks Currencies 1 Sort Filter What If Analysis H5 fx =B25 A B C D E F H i J K L M N 102,675 270,717 1.800 991 2,791 80.00 223,283 $ $ 1 Proposal for Dream Home 2 Elijah and Valerie Foglesong 3 4 Base House Square footage: Main floor 6 Square footage: Basement 7 Total Square footage 8 Base price per square foot 9 Base house price 10 11 Interior Upgrades 12 Granite countertops 13 Hardwood floors 14 Tile floors: main-floor bathrooms 15 Total interior upgrades 16 17 Exterior Upgrades 18 Complete sprinkler system 19 Fence 20 Energy efficient AC 21 Total exterior upgrades 22 23 Lot 24 Table 1: Square Footage Total Sq Ft Base Price Total Cost 1.800 $ 144,000 $ 270,717 2,000 $ 160,000 $ 286,717 2,200 $ 176,000 $ 302,717 2,400 $ 192,000 $ 318,717 wa 2,600 $ 208,000 $ 334,717 2,800 $ w 224,000 S 350,717 3,000 $ 240,000 $ 366,717 3,200 $ 256,000 $ 382,717 3,400 $ 272,000 $ 398,717 3.600 $ 288,000 $ 414,717 Table 2: Square Footage & Lot Total Sq Ft. $ 90,000 $ 1.00 1,800 $ 258,042 $ 2,000 $ 274,042 $ 2,200 $ 290,042 $ 2,400 $ 306,042 $ 2,600 $ 322,042 $ 2,800 $ 338,042 $ 3,000 $ 354,042 $ 3,200 $ 370,042 $ 3,400 $ 386,042 $ 3,600 $ 402,042 $ 96,000 $ 264,042 $ 280,042 $ 296,042 $ 312,042 S wa 328,042 $ 344,042 $ 360,042 $ 376,042 $ 392,042 $ 408,042 $ 286,717 302,717 318,717 334.717 """ 350,717 366,717 382,717 398,717 414,717 $ $ $ $ 3,000 7,500 3,200 13,700 $ $ $ $ 3,525 2,942 3,875 10,342 $ 102,675