Excel Project EXP ECH06 H2 - Housing Construction Cost Variables 1.1

Buy here:http://homework.plus/excel-project-exp-ech06-h2-housing-construction-cost-variables-1-1/

Excel Project EXP ECH06 H2 - Housing Construction Cost Variables 1.1

**EXP ECH06 H2 - Housing Construction Cost Variables 1.1**

**Project Description:**

*Your friends, Elijah and Valerie Foglesong, want to build their
dream house. They identified tentative costs, but they cannot afford
the $414,717 estimated cost. You will use Goal Seek to determine an
estimate of the total finished square footage they can afford. To
help provide more flexibility in their decision-making, you will
create a data table listing various finished square footages and
their effects on the base house cost and total cost. Finally, you
will create another data table showing combinations of square
footages and lot prices to identify total costs.*

**Instructions:**

For the purpose of grading the project you are required to perform the following tasks:

**Step**

**Instructions**

**Points Possible**

**1**

Start Excel. Open *exploring_e06_grader_h2_House.xlsx* and
save the workbook as**exploring_e06_grader_h2_House_LastFirst**.

0.000

**2**

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

12.000

**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.000

**4**

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

12.000

**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.000

**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.000

**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.000

**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.000

**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.000

**10**

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

10.000

**11**

Save the workbook. Close the workbook and exit Excel. Submit the workbook as directed.

0.000

**Total Points**

**100.000**