Question

1	Start Excel. Open exploring_e06_grader_h2_House.xlsx and save the workbook as exploring_e06_grader_h2_House_LastFirst.	0
2	Use Goal Seek to determine the total finished square footage to meet the total cost goal of $350,000.	12
3	Enter a series of total square footages 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.	12
4	Enter a reference to the base house price in cell E5 and a reference to the total estimated cost in cell F5.	12
5	Complete the data table using the appropriate input cell. 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.	12
6	Identify the square footage, base price, and total cost in the data table that comes closest to their goal. Apply Blue, Accent 1, Lighter 40% fill color to those cells.	8
7	Copy and paste the square footage substitution values in Table 1 to the range H6:H15. Remove the fill color. Enter these lot price substitution values in the range I5:K5: 90000, 96000, and 102675, respectively. Format these values with the Accounting Number Format with zero decimal places and Blue font.	12
8	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.	12
9	Complete the second data table using the appropriate input cells. Apply Blue, Accent 1, Lighter 40% fill color to the total price in each column that comes closest to their goal.	10
10	Format results in both tables with Accounting Number Format with zero decimal places.	10
11	Save the workbook. Close the workbook and exit Excel. Submit the workbook as directed.	0

G H Proposal for Dream Home Elijah and Valerie Foglesong Table 2: Square Footage & Lot Table 1: Square Footage Total Sq Ft Base House Square footage: Main floor Square footage: Basement Total Square footage Base price per square foot Base house price 1,800 1,800 3,600 80.00 288,000 $ $ 1 Interior Upgrades Granite countertops Hardwood floors 1 Tile floors: main-floor bathrooms Total interior upgrades $ $ $ $ 3,000 7,500 3,200 13,700 Exterior Upgrades B Complete sprinkler system 3 Fence Energy efficient AC Total exterior upgrades $ $ $ $ 3,525 2,942 3,875 10,342 3 Lot $ 102,675 1 5 Total Estimated Cost $ 414,717 3 Estimate

Answer 1

We Have The Following Excel Sheet For This Question.

G H Proposal for Dream Home Elijah and Valerie Foglesong Table 2: Square Footage & Lot Table 1: Square Footage Total Sq Ft Base House Square footage: Main floor Square footage: Basement Total Square footage Base price per square foot Base house price 1,800 1,800 3,600 80.00 288,000 $ $ 1 Interior Upgrades Granite countertops Hardwood floors 1 Tile floors: main-floor bathrooms Total interior upgrades $ $ $ $ 3,000 7,500 3,200 13,700 Exterior Upgrades B Complete sprinkler system 3 Fence Energy efficient AC Total exterior upgrades $ $ $ $ 3,525 2,942 3,875 10,342 3 Lot $ 102,675 1 5 Total Estimated Cost $ 414,717 3 Estimate

Use Goal Seek to determine the total finished square footage to meet the total cost goal of $350,000.

Click What-If Analysis in the Data Tools group under the Data tab. Select Goal Seek.

Click cell B25 to enter cell reference in the Set cell box.

Type 350000 in the To value box.

Click cell B7 to enter cell reference in the By changing cell box.

Click OK in the Goal Seek dialog box. Click OK in the Goal Seek Status dialog box.

B7 for A B с D E F G H 1 J K Table 2: Square Footage & Lot Table 1: Square Footage Total Sq Ft 1 Proposal for Dream Home 2 Elijah and Valerie Foglesong 3 4 Base House 5 Square footage: Main floor 1.800 6 Square footage: Basement 1,800 7 Total Square footage 3,600 8 Base price per square foot $ 80.00 9 Base house price $ 288,000 10 11 Interior Upgrades 12 Granite countertops $ 3,000 13 Hardwood floors $ 7,500 14 Tile floors: main-floor bathrooms $ 3,200 15 Total interior upgrades $ 13,700 16 17 Exterior Upgrades 18 Complete sprinkler system $ 3,525 19 Fence $ 2,942 20 Energy efficient AC $ 3,875 21 Total exterior upgrades $ 10,342 22 23 Lot $ 102,675 24 25 Total Estimated Cost $ 414,717 26 X х ? Goal Seek Set cell: B25 To value: 350000 By changing cell: B7| OK Cancel

F28 ✓ for C D E F G H I I J K Table 1: Square Footage Total Sq Ft Table 2: Square Footage & Lot A B 1 Proposal for Dream Home 2. Elijah and Valerie Foglesong 3 4 Base House 5 Square footage: Main floor 1,800 6 Square footage: Basement 991 7 Total Square footage 2,791 8 Base price per square foot $ 80.00 9 Base house price S 223,283 10 11 Interior Upgrades 12 Granite countertops $ 3,000 13 Hardwood floors $ 7,500 14 Tile floors: main-floor bathrooms $ 3,200 15 Total interior upgrades $ 13,700 16 17 Exterior Upgrades 18 Complete sprinkler system $ 3,525 19 Fence $ 2,942 20 Energy efficient AC $ 3,875 21 Total exterior upgrades $ 10,342 22 23 Lot $ 102,675 24 25 Total Estimated Cost $ 350,000 Goal Seek Status ? X х Step Goal Seeking with Cell B25 found a solution. Target value: 350000 Current value: $350,000 Pause OK Cancel

F28 fx A B C D E F G H I J к Table 2: Square Footage & Lot Table 1: Square Footage Total Sq Ft 1 Proposal for Dream Home 2 Elijah and Valerie Foglesong 3 4 Base House 5 Square footage: Main floor 1,800 6 Square footage: Basement 991 7 Total Square footage 2,791 8 Base price per square foot $ 80.00 9 Base house price $ 223,283 10 11 Interior Upgrades 12 Granite countertops $ 3,000 13 Hardwood floors $ 7,500 14 Tile floors: main-floor bathrooms $ 3,200 15 Total interior upgrades $ 13,700 16 17 Exterior Upgrades 18 Complete sprinkler system $ 3,525 19 Fence $ 2,942 20 Energy efficient AC $ 3,875 21 Total exterior upgrades $ 10,342 22 23 Lot $ 102,675 24 25 Total Estimated Cost $ 350,000

Enter a series of total square footages 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.

Enter a series of substitution values by doing the following:

Click cell D6 and type 1800. Click Ctrl+Enter.

Click Fill in the Editing group under the Home tab. Select Series.

Click Columns in the Series in section. Type 200 in the Step value box and type 3600 in the Stop value box.

Click OK.

Apply formatting changes to cell range D6:D15 by doing the following:

Select cell range D6:D15.

Click Comma Style in the Number group under the Home tab. Click Decrease Decimal twice to display the cell range with zero decimal places.

Click the Font color arrow and select Blue font color under the Standard Colors section

D6 1800 A B C D E F G H I J K 2 Table 2: Square Footage & Lot Table 1: Square Footage Total Sq Ft 18001 Series ? X 1 Proposal for Dream Home Elijah and Valerie Foglesong 3 4 Base House 5 Square footage: Main floor 1,800 6 Square footage: Basement 991 7 Total Square footage 2,791 8 Base price per square foot $ 80.00 9 Base house price $ 223,283 10 11 Interior Upgrades 12 Granite countertops $ 3,000 13 Hardwood floors $ 7,500 14 Tile floors: main-floor bathrooms $ 3,200 15 Total interior upgrades $ 13,700 16 17 Exterior Upgrades 18 Complete sprinkler system $ 3,525 19 Fence $ 2,942 20 Energy efficient AC $ 3,875 21 Total exterior upgrades $ 10,342 22 23 Lot $ 102,675 24 25 Total Estimated Cost $ 350,000 26 Series in Rows © Columns Type Linear Growth Date AutoFill Date unit Day Weekday Month Year Trend Step value: 200 Stop value: 36001 OK Cancel

H34 X for D D E F G H I J K 1 A B Proposal for Dream Home Elijah and Valerie Foglesong 2 3 Table 2: Square Footage & Lot Table 1: Square Footage Total Sq Ft 1800 2000 4 Base House 5 Square footage: Main floor 1,800 6 Square footage: Basement 991 7 Total Square footage 2,791 8 Base price per square foot $ 80.00 9 Base house price $ 223,283 10 11 Interior Upgrades 12 Granite countertops $ 3,000 13 Hardwood floors $ 7,500 14 Tile floors: main-floor bathrooms $ 3,200 15 Total interior upgrades $ 13,700 16 17 Exterior Upgrades 18 Complete sprinkler system $ 3,525 19 Fence $ 2,942 20 Energy efficient AC $ 3,875 21 Total exterior upgrades $ 10,342 22 23 Lot $ 102,675 24 25 Total Estimated Cost $ 350,000 2200 2400 2600 2800 3000 3200 3400 3600

E5 C D E F G H 1 J K Table 2: Square Footage & Lot A B 1 Proposal for Dream Home 2 Elijah and Valerie Foglesong 3 4 Base House 5 Square footage: Main floor 1,800 6 Square footage: Basement 991 7 Total Square footage 2,791 8 Base price per square foot $ 80.00 9 Base house price $ 223,283 10 11 Interior Upgrades 12 Granite countertops $ 3,000 13 Hardwood floors $ 7,500 14 Tile floors: main-floor bathrooms $ 3,200 15 Total interior upgrades $ 13,700 16 17 Exterior Upgrades 18 Complete sprinkler system $ 3,525 19 Fence $ 2,942 20 Energy efficient AC $ 3,875 21 Total exterior upgrades $ 10,342 22 23 Lot $ 102,675 24 25 Total Estimated Cost $ 350,000 26 Table 1: Square Footage Total Sq Ft 1,800 2,000 2,200 2,400 2,600 2,800 3,000 3,200 3,400 3,600

Enter a reference to the base house price in cell E5 and a reference to the total estimated cost in cell F5.

Enter the following references to formulas in the worksheet:

Click cell E6 and type =B9.

Click cell F6 and type =B25

E5 =B9 A B с D E F G H I J K Table 2: Square Footage & Lot 350,000 1 Proposal for Dream Home 2 Elijah and Valerie Foglesong 3 4 Base House 5 Square footage: Main floor 1,800 6 Square footage: Basement 991 7 Total Square footage 2,791 8 Base price per square foot $ 80.00 9 Base house price $ 223,283 10 11 Interior Upgrades 12 Granite countertops $ 3,000 13 Hardwood floors $ 7,500 14 Tile floors: main-floor bathrooms $ 3,200 15 Total interior upgrades $ 13,700 16 17 Exterior Upgrades 18 Complete sprinkler system $ 3,525 19 Fence $ 2,942 20 Energy efficient AC $ 3,875 21 Total exterior upgrades $ 10,342 22 23 Lot $ 102,675 24 25 Total Estimated Cost $ 350,000 26 Table 1: Square Footage Total Sq Ft $ 223,283 ! $ 1,800 2,000 2,200 2,400 2,600 2,800 3,000 3,200 3,400 3,600

Complete the data table using the appropriate input cell. 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.

Click the one-variable data table by doing the following:

Select cell range D5:F15.

Click What-If Analysis in the Data Tool group under the Data tab. Select Data Table.

Click in the Column input cell box and then click cell B7 to enter a cell reference. Click OK.

Select cell range E6:G15 and click Accounting Number Format in the Number group under the Home tab. Click Decrease Decimal twice so the data displays with zero decimal places.

Create column headings by doing the following:

Click cell E5 and click the Number Dialog Box Launcher in the Number group. Click Custom in the Category list. Scroll the Type list and select General. Select General in the Type box and type “Base Price”. Click OK.

Click cell F5 and click the Number Dialog Box Launcher in the Number group. Click Custom in the Category list. Scroll the Type list and select General. Select General in the Type box and type “Total Cost”. Click OK.

Select cell range E5:F5. Click the Font color arrow and select Blue font color under the Standard Colors section. Click Center in the Alignment group. Click Bold in the Font group.

B7 f Total Sq Ft с D E F G H I j K Table 2: Square Footage & Lot - A B 1 Proposal for Dream Home 2 Elijah and Valerie Foglesong 3 4 Base House 5 Square footage: Main floor 1,800 6 Square footage: Basement 991 7 Total Square footage 2,791 ! 8 Base price per square foot $ 80.00 9 Base house price $ 223,283 10 11 Interior Upgrades 12 Granite countertops $ 3,000 13 Hardwood floors $ 7,500 14 Tile floors: main-floor bathrooms $ 3,200 15 Total interior upgrades $ 13,700 16 17 Exterior Upgrades 18 Complete sprinkler system $ 3,525 19 Fence $ 2,942 20 Energy efficient AC $ 3,875 21 Total exterior upgrades $ 10,342 22 23 Lot $ 102,675 24 25 Total Estimated Cost $ 350,000 26 Table 1: Square Footage Total Sq Ft $ 223,283 $ 350,000 1,800 2,000 2,200 2,400 2,600 2,800 3,000 3,200 3,400 Data Table 3,600 Row input cell: Column input cell: B7 X х 1 OK Cancel

E5 fa =B9 A B с D E F G H I J K Table 2: Square Footage & Lot Table 1: Square Footage Total Sq Ft $ 223,283 $ 350,000 1,800 $ 144,000 $ 270, 717 2,000 $ 160,000 $ 286,717 2,200 $ 176,000 $ 302,717 2,400 $ 192,000 $ 318,717 Format Cells ? х Number Alignment Font Border Fill Protection 1 Proposal for Dream Home 2 Elijah and Valerie Foglesong 3 4 Base House 5 square footage: Main floor 1,800 6 Square footage: Basement 991 7 Total Square footage 2,791 8 Base price per square foot $ 80.00 9 Base house price $ 223,283 10 11 Interior Upgrades 12 Granite countertops $ 3,000 13 Hardwood floors $ 7,500 14 Tile floors: main-floor bathrooms $ 3,200 15 Total interior upgrades $ 13,700 16 17 Exterior Upgrades 18 Complete sprinkler system $ 3,525 19 Fence $ 2,942 20 Energy efficient AC $ 3,875 21 Total exterior upgrades $ 10,342 22 23 Lot $ 102,675 24 25 Total Estimated Cost $ 350,000 26 27 28 29 Sample Base Price Category: General Number Currency Accounting Date Time Percentage Fraction Scientific Text Special Custom Type: : \Ba\s\e \Pric el General 0 0.00 ###O #,##0.00 ###0;-# ##0 # ##0;(Red)-# ##0 # ##0.00:-# ##0.00 #,##0.00; (Red)-###0.00 *# *#0; -###0 *#,##0;[Red -# ##0 Delete Type the number format code, using one of the existing codes as a starting point. 30 31 OK Close 32 33

F5 fo =B25 C D E F G H I K Table 2: Square Footage & Lot Table 1: Square Footage Total Sq Ft Base Price 350000 1,800 $144,000.00 $ 270,717.00 2,000 $160,000.00 $ 286,717.00 2,200 $176,000.00 $ 302,717.00 2,400 $ 192,000.00 $318,717.00 Format Cells ? X х Number Alignment Font Border Fill Protection A B B 1 Proposal for Dream Home 2 Elijah and Valerie Foglesong 3 4 Base House 5 Square footage: Main floor 1,800 6 Square footage: Basement 991 7 Total Square footage 2,791 8 Base price per square foot $ 80.00 9 Base house price $223,283.00 10 11 Interior Upgrades 12 Granite countertops $ 3,000.00 13 Hardwood floors $ 7,500.00 14 Tile floors: main-floor bathrooms $ 3,200.00 15 Total interior upgrades $ 13,700.00 16 17 Exterior Upgrades 18 Complete sprinkler system $ 3,525.00 19 Fence $ 2,942.00 20 Energy efficient AC $ 3,875.00 21 Total exterior upgrades $ 10,342.00 22 23 Lot $102,675.00 24 25 Total Estimated Cost $350,000.00 26 Sample Total Cost Category: General Number Currency Accounting Date Time Percentage Fraction Scientific Text Special Custom Type: Total Cost General 0 0.00 #,##0 ###0.00 #,##0;-#,##0 #,##0;[Red)-#,##0 # ##0.00:-# ##0.00 # ##0.00 (Red)-###0.00 *# ##0;*###O * #,##0;[Red] -#,##O Delete 27 Type the number format code, using one of the existing codes as a starting point 28 29 30 31 32 OK Close 33 34

129 X C D E F G H I J K Table 2: Square Footage & Lot 4 A B 1 Proposal for Dream Home 2 Elijah and Valerie Foglesong 3 4 Base House 5 Square footage: Main floor 1,800 6 Square footage: Basement 991 7 Total Square footage 2,791 8 Base price per square foot $ 80.00 9 Base house price $223,283.00 10 11 Interior Upgrades 12 Granite countertops $ 3,000.00 13 Hardwood floors $ 7,500.00 14 Tile floors: main-floor bathrooms $ 3,200.00 15 Total interior upgrades $ 13,700.00 16 17 Exterior Upgrades 18 Complete sprinkler system $ 3,525.00 19 Fence $ 2,942.00 20 Energy efficient AC $ 3,875.00 21 Total exterior upgrades $ 10,342.00 22 23 Lot $102,675.00 24 25 Total Estimated Cost $350,000.00 26 27 Table 1: Square Footage Total Sq Ft Base Price Total Cost 1,800 $ 144,000 S 270,717 2,000 $ 160,000 $ 286,717 2,200 $ 176,000 $ 302,717 2,400 $ 192,000 $ 318,717 2,600 $ 208,000 S 334,717 2,800 $ 224,000 $ 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

Identify the square footage, base price, and total cost in the data table that comes closest to their goal. Apply Blue, Accent 1, Lighter 40% fill color to those cells.

129 X fx A B C D E F G H 1 K Table 2: Square Footage & Lot 1 Proposal for Dream Home 2 Elijah and Valerie Foglesong 3 4 Base House 5 Square footage: Main floor 1,800 6 Square footage: Basement 991 7 Total Square footage 2,791 8 Base price per square foot $ 80.00 9 Base house price $223,283.00 10 11 Interior Upgrades 12 Granite countertops $ 3,000.00 13 Hardwood floors $ 7,500.00 14 Tile floors: main-floor bathrooms $ 3,200.00 15 Total interior upgrades $ 13,700.00 16 17 Exterior Upgrades 18 Complete sprinkler system $ 3,525.00 19 Fence $ 2,942.00 20 Energy efficient AC $ 3,875.00 21 Total exterior upgrades $ 10,342.00 22 23 Lot $102,675.00 24 25 Total Estimated Cost $350,000.00 26 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 2,600 $ 208,000 $ 334,717 2,800 $ 224,000 $ 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

Copy and paste the square footage substitution values in Table 1 to the range H6:H15. Remove the fill color. Enter these lot price substitution values in the range I5:K5: 90000, 96000, and 102675, respectively. Format these values with the Accounting Number Format with zero decimal places and Blue font.

Set up the variables for the two-variable data table by doing the following:

Select cell range D6:D15 and click Copy in the Clipboard group. Click cell H6 and then click Paste. Press Esc.

Remove the fill color from any cells in column H.

Click cell I5 and type 90000. Click cell J5 and type 96000. Click cell K5 and type 102675.

Select cell range I5:K5 and click Accounting Number Format in the Number group under the Home tab. Click Decrease Decimal twice so the data displays with zero decimal places. Click the Font color arrow and select Blue font color under the Standard Colors section.

J31 fo с D E F G H 1 K 96,000 $ 102,675 Table 2: Square Footage & Lot $ 90,000 $ 1,800 2,000 2,200 2,400 2,600 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 2,600 $ 208,000 $ 334,717 2,800 $ 224,000 $ 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 A B 1 Proposal for Dream Home 2 Elijah and Valerie Foglesong 3 4 Base House 5 Square footage: Main floor 1,800 6 Square footage: Basement 991 7 Total Square footage 2,791 8 Base price per square foot $ 80.00 9 Base house price $223,283.00 10 11 Interior Upgrades 12 Granite countertops $ 3,000.00 13 Hardwood floors $ 7,500.00 14 Tile floors: main-floor bathrooms $ 3,200.00 15 Total interior upgrades $ 13,700.00 16 17 Exterior Upgrades 18 Complete sprinkler system $ 3,525.00 19 Fence $ 2,942.00 20 Energy efficient AC $ 3,875.00 21 Total exterior upgrades $ 10,342.00 22 23 Lot $102,675.00 24 25 Total Estimated Cost $350,000.00 26 2,800 3,000 3,200 3,400 3,600

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.

Complete the two-variable data table by doing the following:

Click cell H5 and type =B25

Select cell range H5:K15.

Click What-If Analysis in the Data Tool group under the Data tab. Select Data Table.

Click in the Row input cell box and then click cell B23 to enter a cell reference.

Click in the Column input cell box and then click cell B7 to enter a cell reference. Click OK.

Select cell range I6:K15 and click Accounting Number Format in the Number group under the Home tab. Click Decrease Decimal twice so the data displays with zero decimal places.

Click cell H5 and click the Number Dialog Box Launcher in the Number group. Click Custom in the Category list. Scroll the Type list and select General. Select General in the Type box and type “Total Sq Ft”. Click OK

Click cell H5 and click Bold in the Font group, then click the Font color arrow and select Blue font color under the Standard Colors section.

SUM х ✓ fi =B25 C D E F G H 1 J K 1 A B Proposal for Dream Home Elijah and Valerie Foglesong 2 3 96,000 $ 102,675 4 Base House 5 Square footage: Main floor 1,800 6 Square footage: Basement 991 7 Total Square footage 2,791 8 Base price per square foot $ 80.00 9 Base house price $223,283.00 10 11 Interior Upgrades 12 Granite countertops $ 3,000.00 13 Hardwood floors $ 7,500.00 14 Tile floors: main-floor bathrooms $ 3,200.00 15 Total interior upgrades $ 13,700.00 16 17 Exterior Upgrades 18 Complete sprinkler system $ 3,525.00 19 Fence $ 2,942.00 20 Energy efficient AC $ 3,875.00 21 Total exterior upgrades $ 10,342.00 22 23 Lot $102,675.00 24 25 Total Estimated Cost $350,000.00 26 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 2,600 $ 208,000 $ 334,717 2,800 $ 224,000 $ 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 =B25 = $ 90,000 $ 1,800 2,000 2,200 2,400 2,600 2,800 3,000 3,200 3,400 3,600

B7 =B25 B с D E F G H I K 1 А Proposal for Dream Home Elijah and Valerie Foglesong 2 3 3 96,000 $ 102,675 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 2,600 $ 208,000 $ 334,717 2,800 $ 224,000 $ 350,717 3,000 $ 240,000 $ 3,200 $ 256,000 $ 382,717 3,400 $ 272,000 $ 3,600 $ 288,000 $ 414,717 Table 2: Square Footage & Lot $ 350,000 $ 90,000 $ 1,800 2,000 2,200 2,400 2,600 2,800 3,000 3,200 3,400 3,600 4 Base House 5 Square footage: Main floor 1,800 6 Square footage: Basement 991 7 Total Square footage 2,791 ! 8 Base price per square foot $ 80.00 9 Base house price $223,283.00 10 11 Interior Upgrades 12 Granite countertops $ 3,000.00 13 Hardwood floors $ 7,500.00 14 Tile floors: main-floor bathrooms $ 3,200.00 15 Total interior upgrades $ 13,700.00 16 17 Exterior Upgrades 18 Complete sprinkler system $ 3,525.00 19 Fence $ 2,942.00 20 Energy efficient AC $ 3,875.00 21 Total exterior upgrades $ 10,342.00 22 23 Lot $102,675.00 24 25 Total Estimated Cost $350,000.00 26 366,717 398,717 Data Table ? X 1 Row input cell: B23 Column input cell: B7|| 1 OK Cancel

L31 A B с D E F H I K 1 2 Proposal for Dream Home Elijah and Valerie Foglesong 3 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 2,600 $ 208,000 $ 334,717 2,800 $ 224,000 $ 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 $ 350,000 $ 90,000 $ 96,000 $ 102,675 1,800 $ 258,042 $ 264,042 $ 270,717 2,000 $ 274,042 $ 280,042 $ 286,717 2,200 $ 290,042 $ 296,042 $ 302,717 2,400 $ 306,042 S 312,042 $ 318,717 2,600 $ 322,042 $ 328,042 $ 334,717 2,800 $ 338,042 $ 344,042 $ 350,717 3,000 $ 354,042 $ 360,042 $ 366,717 3,200 $ 370,042 $ 376,042 $ 382,717 3,400 $ 386,042 $ 392,042 $ 398,717 3,600 $ 402,042 $ 408,042 $ 414,717 4 Base House 5 Square footage: Main floor 1,800 6 Square footage: Basement 991 7 Total Square footage 2,791 8 Base price per square foot $ 80.00 9 Base house price $223,283.00 10 11 Interior Upgrades 12 Granite countertops $ 3,000.00 13 Hardwood floors $ 7,500.00 14 Tile floors: main-floor bathrooms $ 3,200.00 15 Total interior upgrades $ 13,700.00 16 17 Exterior Upgrades 18 Complete sprinkler system $ 3,525.00 19 Fence $ 2,942.00 20 Energy efficient AC $ 3,875.00 21 Total exterior upgrades $ 10,342.00 22 23 Lot $102,675.00 24 25 Total Estimated Cost $350,000.00 26 27

HS =B25 с E F G H I J K L Table 2: Square Footage & Lot 3500000 $ 90,000 $ 96,000 $ 102,675 1,800 $ 258,042.00 $ 264,042.00 $270,717.00 2,000 $274,042.00 $ 280,042.00 $ 286,717.00 2,200 $ 290,042.00 $296,042.00 $302,717.00 2,400 $ 306,042.00 $312,042.00 $318,717.00 2.600 $222 04200 $228.042.00 $ 224 717.00 $ ? 318,717 х А B 1 1 Proposal for Dream Home 2 Elijah and Valerie Foglesong 3 4 Base House 5 Square footage: Main floor 1,800 6 Square footage: Basement 991 7 Total Square footage 2,791 8 Base price per square foot $ 80.00 9 Base house price $223,283.00 10 11 Interior Upgrades 12 Granite countertops $ 3,000.00 13 Hardwood floors $ 7,500.00 14 Tile floors: main-floor bathrooms $ 3,200.00 15 Total interior upgrades $ 13,700.00 16 17 Exterior Upgrades 18 Complete sprinkler system $ 3,525.00 19 Fence $ 2,942.00 20 Energy efficient AC $ 3,875.00 21 Total exterior upgrades $ 10,342.00 22 23 Lot $102,675.00 24 25 Total Estimated Cost $350,000.00 26 Font 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 $ 2,600 $ 208 000 $ 224 717 2,800 $ 2 Format Cells 3,000 $ 2 Number Alignment 3,200 $ 2 3,400 $ 2 Category: 3,600 $ 2 General Number Currency Accounting Date Time Percentage Fraction Scientific Text Special Custom Fill Border Protection Sample Total Sq Ft Type: : Total (Sq Ft General 0 0.00 #,##0 ###0.00 ###0; # *#0 # ##0 (Red)-###O # ==0.00:-# =#0.00 #==0.00; (Red)-#,##0.00 *# *#0; -#,##O *#*#0;(Red)-#,##0 Delete 27 28 Type the number format code, using one of the existing codes as a starting point 29 30 31 32 OK Close 33 24

Complete the second data table using the appropriate input cells. Apply Blue, Accent 1, Lighter 40% fill color to the total price in each column that comes closest to their goal.

Identify the total cost in each column of the data table that is closest to the total cost goal of $350,000. Select the corresponding cells in the table and click the Fill color arrow and select Blue, Accent 1, Lighter 40% fill color.

K35 fc B с D E F H I Proposal for Dream Home Elijah and Valerie Foglesong 2 3 4 Base House 5 Square footage: Main floor 1,800 6 Square footage: Basement 991 7 Total Square footage 2,791 8 Base price per square foot $ 80.00 9 Base house price $223,283.00 10 11 Interior Upgrades 12 Granite countertops $ 3,000.00 13 Hardwood floors $ 7,500.00 14 Tile floors: main-floor bathrooms $ 3,200.00 15 Total interior upgrades $ 13,700.00 16 17 Exterior Upgrades 18 Complete sprinkler system $ 3,525.00 19 Fence $ 2,942.00 20 Energy efficient AC $ 3,875.00 21 Total exterior upgrades $ 10,342.00 22 23 Lot $102,675.00 24 25 Total Estimated Cost $350,000.00 as 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 2,600 $ 208,000 $ 334,717 2,800 $ 224,000 $ 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 $ 96,000 $ 102,675 1,800 $ 258,042.00 $ 264,042.00 $ 270,717.00 2,000 $274,042.00 $280,042.00 $286,717.00 2,200 $ 290,042.00 $296,042.00 $ 302,717.00 2,400 $ 306,042.00 $312,042.00 $318,717.00 2,600 $322,042.00 $328,042.00 $334,717.00 2,800 $338,042.00 $344,042.00 $ 350,717.00 3,000 $ 354,042.00 $360,042.00 $366,717.00 3,200 $370,042.00 $376,042.00 $382,717.00 3,400 $386,042.00 $392,042.00 $398,717.00 3,600 $ 402,042.00 $ 408,042.00 $414,717.00

Format results in both tables with Accounting Number Format with zero decimal places.

Select cell range E6:G15 and click Accounting Number Format in the Number group under the Home tab. Click Decrease Decimal twice so the data displays with zero decimal places.

Select cell range I6:K15 and click Accounting Number Format in the Number group under the Home tab. Click Decrease Decimal twice so the data displays with zero decimal places.

K35 X A B E F H I K 1 Proposal for Dream Home 2 Elijah and Valerie Foglesong 3 4 Base House 5 Square footage: Main floor 1,800 6 Square footage: Basement 991 7 Total Square footage 2,791 8 Base price per square foot $ 80.00 9 Base house price $223,283.00 10 11 Interior Upgrades 12 Granite countertops $ 3,000.00 13 Hardwood floors $ 7,500.00 14 Tile floors: main-floor bathrooms $ 3,200.00 15 Total interior upgrades $ 13,700.00 16 17 Exterior Upgrades 18 Complete sprinkler system $ 3,525.00 19 Fence $ 2,942.00 20 Energy efficient AC $ 3,875.00 21 Total exterior upgrades $ 10,342.00 22 23 Lot $102,675.00 24 25 Total Estimated Cost $350,000.00 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 2,600 $ 208,000 $ 334,717 2,800 $ 224,000 $ 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 $ 96,000 $ 102,679 1,800 $ 258,042.00 $ 264,042.00 $270,717.00 2,000 $274,042.00 $280,042.00 $286,717.00 2,200 $ 290,042.00 $ 296,042.00 $ 302,717.00 2,400 $ 306,042.00 $312,042.00 $318,717.00 2,600 $322,042.00 $328,042.00 $ 334,717.00 2,800 $338,042.00 $344,042.00 $ 350,717.00 3,000 $ 354,042.00 $360,042.00 $366,717.00 3,200 $370,042.00 $376,042.00 $382,717.00 3,400 $386,042.00 $392,042.00 $398,717.00 3,600 $ 402,042.00 $408,042.00 $414,717.00

Please Rate My Answer If You Like It.