View the step-by-step solution to:

Proposed House Costs Jon and Jen Patterson Base House Basement Estimated square footage Base price per square foot Base house price $ 20,000.00 1,875...

Hello there, I need help with my excel class.  the assignment will be turned in through MyItLab to be graded.  Below I will attach the instruction manual, and both excel page downloads that are needed.  Anyone who can finish this for me correctly and in a timely manner I will include the tip to be between half the assignment price and full.

Proposed House Costs Jon and Jen PaTerson Base House Basement $ 20,000.00 EsTmated square footage 1,875 Base price per square foot $ 84.35 Base house price $ 158,156.25 Interior Upgrades Granite countertops $ 3,000.00 Hardwood Foors $ 7,500.00 ±ile Foors in bathroom $ 3,725.00 Kitchen appliances $ 2,895.99 ±otal interior upgrades $ 17,120.99 Exterior Upgrades Complete sprinkler system $ 3,125.35 Sod $ 2,500.00 ±rees $ 4,200.00 ²ence $ 2,800.00 Energy e³cient AC $ 3,875.50 ±otal exterior upgrades $ 16,500.85 Lot ±hird acre $ 95,000.00 ±otal Es²mated Cost $ 286,778.09
Background image of page 1
Proposed House Costs Jon and Jen PaTerson Base House Basement $ 20,000.00 EsTmated square footage 1,875 Base price per square foot $ 84.35 Base house price $ 158,156.25 Interior Upgrades Granite countertops $ 3,000.00 Hardwood Foors $ 7,500.00 ±ile Foors in bathroom $ 3,725.00 Kitchen appliances $ 2,895.99 ±otal interior upgrades $ 17,120.99 Exterior Upgrades Complete sprinkler system $ 3,125.35 Sod $ 2,500.00 ±rees $ 4,200.00 ²ence $ 2,800.00 Energy e³cient AC $ 3,875.50 ±otal exterior upgrades $ 16,500.85 Lot ±hird acre $ 95,000.00 ±otal Es²mated Cost $ 286,778.09
Background image of page 1
Ofce 2013 – myitlab:grader – Instructions Exploring Series Vol. 2 Collaboration and Workbook Distribution Project Description: You are an assistant sales manager for a contractor who builds custom houses. Your job is to prepare initial estimates for people who want to purchase a lot and build a house in the development community. As you prepare plans, you get feedback from the oFce manager, incorporate changes, and ±nalize the workbook to distribute to potential buyers. Instructions: For the purpose o± grading the project you are required to per±orm the ±ollowing tasks: Step Instructions Points Possible 1 Enter your name as the user name in the Excel Options dialog box i± necessary. Add the E-mail command to the Quick Access Toolbar. Add the Compare and Merge Workbooks command to the Quick Access Toolbar, i± necessary. Open exploring_e11_grader_a1.xlsx , and then save it as e11c2House_ LastFirst replacing Last²irst with your name. 0 2 Display the Backstage view and add the Author name Student . Enter Grader 02 as the Title property. 5 3 Compare and merge e11c2Anthony.xlsx into your workbook. Delete the Trees row, change the Fence value to $2,735.80 , and then save the workbook. 17 4 Activate the Change Tracking ±eature, highlight all changes, and then create a History worksheet. Open the Select Changes to Accept or Reject dialog box, and then deselect all check boxes. Accept the ²rst change in the workbook. Reject the second change in cell B7, and then continue to accept the remaining changes in the document. 30 5 Insert a comment in cell B15 that Additional upgrades will increase the cost. (include the period). 8 6 Insert a comment in cell B27 that The estimate is subject to change based on market changes prior to signing a contract. (include the period). 8 7 Turn o³ workbook sharing, and then save the workbook. Run the Accessibility Checker, identi±y potential problems, and then ²x the warning issues detected. Close the Accessibility Checker task pane. Run the Compatibility Checker, correct any signi²cant loss o± ²delity issues i± any, and ignore any minor loss o± ²delity issues. 10 8 Insert a ±ooter with the sheet name code in the center, and the ²le name code on the right side. 5 9 Add a Microso±t Ofce Signature Line with the name Exploring Series Student . 7 Updated: 08/23/2013 1 E_CH11_EXPV2_A1_Instructions.docx
Background image of page 1
Ofce 2013 – myitlab:grader – Instructions Exploring Series Vol. 2 Step Instructions Points Possible 10 Mark the workbook as Fnal. 10 11 Save the Fle and close Excel. Submit the e11c2House_ LastFirst.xlsx Fle as directed. 0 Total Points 100 Updated: 08/23/2013 2 E_CH11_EXPV2_A1_Instructions.docx
Background image of page 2
Sign up to view the entire interaction

Top Answer

Great question... View the full answer

e11c2House_ crafty1993.xlsx

Proposed House Costs
Jon and Jen Patterson
Base House
Basement
Estimated square footage
Base price per square foot
Base house price $ 20,000.00
1,875
$
85.95
$ 161,156.25 Interior Upgrades
Granite...

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online