Advanced Excel Homeworks


Office 2016 – myitlab:grader – Instructions Excel Project

EX16_XL_CH06_GRADER_ML1_HW – Housing Cost 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



Updated: 09/11/2017 1 Current_Instruction.docx



Proposal for Dream Home
Elijah and Valerie Foglesong
Base House Table 1: Square Footage Table 2: Square Footage & Lot
Square footage: Main floor 1,800 Total Sq Ft
Square footage: Basement 1,800
Total Square footage 3,600
Base price per square foot $ 80.00
Base house price $ 288,000
Interior Upgrades
Granite countertops $ 3,000
Hardwood floors $ 7,500
Tile floors: main-floor bathrooms $ 3,200
Total interior upgrades $ 13,700
Exterior Upgrades
Complete sprinkler system $ 3,525
Fence $ 2,942
Energy efficient AC $ 3,875
Total exterior upgrades $ 10,342
Lot $ 102,675
Total Estimated Cost $ 414,717
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
Looking for a Similar Assignment? Our Experts can help. Use the coupon code SAVE30 to get your first order at 30% off!

Hi there! Click one of our representatives below and we will get back to you as soon as possible.

Chat with us on WhatsApp