##### Excel Project EXP ECH06 H2 - Housing Construction Cost Variables 1.1

0
Set Details Share
created 2 years ago by Seleyman
360 views
Excel Project EXP ECH06 H2 - Housing Construction Cost Variables 1.1
Page to share:
Embed this setcancel
COPY
code changes based on your size selection
Size:
X
1

Excel Project EXP ECH06 H2 - Housing Construction Cost Variables 1.1

2

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

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 to3,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

## Related pages

abduction movement examplephylum coniferophyta characteristicsxylem vessel sinksurine output more than inputtrade name for epinephrinewhat type of macromolecule is hemoglobinmhc molecules definitionpunnett square crosses involving two traits answersflags and capitalsmitosis and cell cycle terminologywho proved that microorganisms cause diseasewhich parent determines penis sizeexplain the process of urine formationwhat is the lower end of the esophagus termedis ch4 organicthe suprarenal medulla producesis elemental copper a pure substancewhats exocytosisthe large intestine diagramchapter 43 the immune systemformula of photosynthesis and cellular respirationchapter 5 integumentary system answersafi 62-601fetal period of developmentprocess of excitation-contraction couplingwhere does lymph fluid come fromfiesta dinnerware marigoldan exergonic reactionmonomer of triglyceridean allosteric enzymemonocular microscope partsisovolumetric relaxationatitsposition for enema administrationcompared with 31p the radioactive isotope 32p hasa pelvic splanchnic nerve containswhat is a viroidindividual zones of optimal functioningphotosystems are clusters of chlorophyll and proteinsinfluenza genome sizewhat are viruses that infect bacteria calledwhich cells are specialized lymphocytes that produce antibodiesselect the correct statement about osmosisproconsul apeneisseria pneumoniawhich of these statements is not true about hemophiliaaqueous humor functionwhich of these gametes contains one or more recombinant chromosomeslow epinephrine causeswhat role does neurotransmitters play in neurotransmissiongive two possible functions of the sinusescephalization chfpsychology 101 flashcardsniche examples biologycapsular hydrostatic pressure definitionsurgical asepsis definitionhuman anatomy and physiology quizzesdefinition for ciliaappendectomy body cavitylipolysis and lipogenesiscorynebacterium diphtheriae virulence factorscontralateral responseprintable cell diagramcampbell 9th edition test bank pdfwhat are pleural membranesosmoregulation in terrestrial animalsprime mover definefimbriae and pili differ in that pilibinomial probability experiment calculatorsmallest micro organismcranium definecatcher in the rye chapter 14level 3 anatomy and physiology mock exam answersregions of cerebrumnerve impulse quizlabeled connective tissuelymph transport involves all but which of the followingwhat does the femoral nerve innervatedefine reticular layerwhat is osteoid