Can you please explain how to do to each step. I have supplied you with a screenshot of the spreadsheet and not the actual file because I want to learn how to do it. You do not have to show images just write down how to complete each step.

Your friends, Elijah and Valerie Foglesong, want to build their dream house. They identified tenta- tive 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. Although a builder's overall house design speci- fies the square footage, the Foglesongs can use your data tables to help guide them in their decision. a. Open e06ml House and save it as e06ml House_LastFirst. b. Use Goal Seek to determine the total finished square footage to meet the total cost goal of $350,000. c. 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. Enter references to the base cost and total cost in the appropriate cells on row 5. d. Complete the data table using the appropriate input cell. Apply custom number formats to give appropriate descriptions to the second and third columns. Apply these formats to the headings: bold, center, and Blue font. e. Identify the square footage, base price, and total cost that come closest to their goal. Apply Blue, Accent 1, Lighter 40% fill color to those cells in the data table. f. Copy the square footage substitution values to the range H6:H15 and remove the fill color. Enter these lot price substitution values in the range 15:K5: 90000, 96000, and 102675. Format these values with Accounting Number Format with zero decimal places and Blue font. g. Enter the reference to the total cost formula in the appropriate location for the second data table. Complete the data table using the appropriate input cells. Apply a custom number format to the reference to the formula cell. Apply bold and Blue font color to that cell. Apply Blue, Accent 1, Lighter 40% fill color to the total price in each column that comes closest to their goal. h. Format results in both tables with Accounting Number Format with zero decimal places. i. Create a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side. Adjust the orientation, margins, and scaling to fit on one page. j. Save and close the workbook, and submit it based on your instructor's directions.A B C D E F G H K L Proposal for Dream Home Elijah and Valerie Foglesong 4 Base House Table 1: Square Footage Table 2: Square Footage & Lot Square footage: Main floor 1,800 Total Sq Ft 6 Square footage: Basement 1,800 1,800 Total Square footage 3,600 2,000 8 Base price per square foot 80.00 2,200 Base house price 288,000 2,400 0 2,600 Interior Upgrades 2,800 2 Granite countertops 3,000 3,000 3 Hardwood floors 7,500 3,200 4 Tile floors: main-floor bathrooms 3,200 3,400 5 Total interior upgrades 13,700 3,600 6 7 Exterior Upgrades 8 Complete sprinkler system 3,525 9 Fence 2,942 0 Energy efficient AC 3,875 Total exterior upgrades 10,342 2 3 Lot S 102,675 5 Total Estimated Cost 414,717