Excel Project EXP ECH06 H2 - Housing Construction Cost Variables 1.1

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

Excel Project EXP ECH06 H2 - Housing Construction Cost Variables 1.1

Buy here:/>

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

Start Excel. Open exploring_e06_grader_h2_House.xlsx and save the workbook asexploring_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 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


distinguish between action and absorption spectra for photosynthesisthe female gamete is calledbony remodelingwhere are immovable joints foundtranscription of the structural genes in an inducible operonfastest breed of horsesthe calvin cycle of photosynthesis begins whenossification of the ends of long bonesthe evolution of a coelom was significant becausehow to replicate a dna strandthyroid secretionsnervous control of gastric secretion is provided byurethral orificesstandards define the ____ performance of a product or servicecircannual rhythm definitionvertebral veinsdescribe the cerebrumwhat is a reactant in the calvin cycletunica adventitia functioncellular respiration is the process by which quizletcrucifixion with angels and mourning figuressomatic reflexesanterolateral minames of common acidsimmune system innate and adaptivehow does termination of translation take placelymphatic system vesselstrna rolecampbell biology quizzesrejection region calculator onlineauscultation of abdomenphosphate nucleotide building blockswhat happens when atp is converted to adparterial systolenodes of ranvier functionexample of secondary active transportformaldehyde embalming processin what cavity are the lungs locatedcapillary valveswhat challenges did the continental army face at valley forgecampbell biology 9th edition study guide answerssensory receptors definitioncampbell biology chapter 17the bending of light rays is called reflectionbony orbit anatomydifference between monosaccharides disaccharides and polysaccharidesglucose o2subclavian arteries and veinsphysical features of earthpossibly caused by asthma pneumonia or a severe panic attackcampbell biology chapter 17 test preparationthe gametophyte is green and nutritionally independent inanatomy and physiology multiple choice testhow many protons does a nitrogen atom havehypothalamo-hypophyseal tractwhich of the following is a limitation of the autoclavewhich belongs in the domain eukaryarecombinant dna quizmesenchymal cells are most commonly found indiagram of the digestive tractlist of oncogenic virusesblood vessels that carry blood to the liverenzymes that digest carbohydrates are produced by what organscodon chart circle14-2 human chromosomeseasy ecg quizalveolar ventilation ratelymphatic system consists ofin e coli the lac operon controls thewhat does monopolistic competition have in common with monopolyductless endocrine glandsnursing care plan for acute cholecystitislymph capillaryosteichthyes fertilizationdefine antiserumacid fast staning