© 2016

Excel Project EXP ECH06 H2 - Housing Construction Cost Variables 1.1

Set Details Share
Helpfulness: 0
created 1 year ago by Seleyman

Excel Project EXP ECH06 H2 - Housing Construction Cost Variables 1.1

show more

Excel Project EXP ECH06 H2 - Housing Construction Cost Variables 1.1

Buy here:/>


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.


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



Points Possible


Start Excel. Open exploring_e06_grader_h2_House.xlsx and save the workbook asexploring_e06_grader_h2_House_LastFirst.



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



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.



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



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.



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.



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.



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



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



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


Total Points


Related pages

the slowest step in the clotting process isascetic in a sentencewhat is the electronegativity of co2all bacteria are prokaryotesan overabundance of the neurotransmitter norepinephrinemedical term for excisionwhy is blood classified as a connective tissuebone mass reduction is promoted by which hormoneperipheral nervous system anatomy and physiologypsis spinewho invented refrigerated railroad carswhich organisms have produced the oldest fossil evidenceselect the element with the least metallic characterthe radius articulates with this condyle of the humerussheep brain dissection quizmuscular system diagramswhat is the job of the uretersanatomy of the heart worksheetpredator saltwater tanktranslation in eukaryotes and prokaryotesbody planes and anatomical directions worksheetcatalyze in a sentenceformation of hydrogen bonds requires hydrogen atoms and what elsedefine saprobedamage to the reticular formationlobed fin fishmurmur of tricuspid regurgitationurine chemical compositionpericardial saccampbell biology chapter 6 test preparationprocon org death penaltythree gorges dam geography case studymorganella morganii motilityreticular layer of skinpathogenesis of clostridium botulinumhuman anatomy and physiology lab manual mariebthymus function in endocrine systemwhat are the joints in the skull calledgreat gatsby charactersfundamentals of nursing volume 1biology practice quizocga 16-8-2function of loop of henleregional terms quizdescribe the digestive tractbiochemistry pathways made easynucleotides contain all of the following exceptwhich of the following types of muscles are striatedhomeostasis control centerbipolar neurons are commonly ________the respiratory mucosa is continuous through thefrederick griffith transformation experimentbody parts in spanish quizchapter 13 meiosis and sexual life cycles study guide answersradial nerve diagramdermal layer responsible for fingerprintssister chromatids are joined at thestructure and function of the alimentary canalcohesion and adhesion watermuscles of pectoral girdledefine repolarizationforward shrugstropical rainforest food pyramidanatomy of the digestive system review sheetwhat substance makes up the bulk of a toothinjection landmarkswhat is embedded in the phospholipid bilayercarbohydrates lipids proteins nucleic acidstest ouchterlonylaboratory experiments in microbiology answerswhat is the function of the ligamentum arteriosumkolbe synthesisanatomy terminology quiz