Office 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 office manager, incorporate changes, and finalize the workbook to distribute to potential buyers. Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible 1 Enter your name as the user name in the Excel Options dialog box if necessary. Add the E-mail command to the Quick Access Toolbar. Add the Compare and Merge Workbooks command to the Quick Access Toolbar, if necessary. Open exploring_e11_grader_a1.xlsx, and then save it as e11c2House_ LastFirst replacing LastFirst 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 feature, 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 first 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 off workbook sharing, and then save the workbook. Run the Accessibility Checker, identify potential problems, and then fix the warning issues detected. Close the Accessibility Checker task pane. Run the Compatibility Checker, correct any significant loss of fidelity issues if any, and ignore any minor loss of fidelity issues. 10 8 Insert a footer with the sheet name code in the center, and the file name code on the right side. 5 9 Add a Microsoft Office Signature Line with the name Exploring Series Student. 7 Updated: 08/23/2013 1 E_CH11_EXPV2_A1_Instructions.docx Office 2013 - myitlab:grader - Instructions Step Exploring Series Vol. 2 Points Possible Instructions 10 Mark the workbook as final. 10 11 Save the file and close Excel. Submit the e11c2House_ LastFirst.xlsx file as directed. Total Points Updated: 08/23/2013 2 0 100 E_CH11_EXPV2_A1_Instructions.docx 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 $ 84.35 $ 158,156.25 Interior Upgrades Granite countertops Hardwood floors Tile floors in bathroom Kitchen appliances Total interior upgrades $ $ $ $ $ 3,000.00 7,500.00 3,725.00 2,895.99 17,120.99 Exterior Upgrades Complete sprinkler system Sod Trees Fence Energy efficient AC Total exterior upgrades $ $ $ $ $ $ 3,125.35 2,500.00 4,200.00 2,800.00 3,875.50 16,500.85 Lot Third acre $ 95,000.00 Total Estimated Cost $ 286,778.09 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 $ 84.35 $ 158,156.25 Interior Upgrades Granite countertops Hardwood floors Tile floors in bathroom Kitchen appliances Total interior upgrades $ $ $ $ $ 3,000.00 7,500.00 3,725.00 2,895.99 17,120.99 Exterior Upgrades Complete sprinkler system Sod Trees Fence Energy efficient AC Total exterior upgrades $ $ $ $ $ $ 3,125.35 2,500.00 4,200.00 2,800.00 3,875.50 16,500.85 Lot Third acre $ 95,000.00 Total Estimated Cost $ 286,778.09 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 $ 84.35 $ 158,156.25 Interior Upgrades Granite countertops Hardwood floors Tile floors in bathroom Kitchen appliances Total interior upgrades $ $ $ $ $ 3,000.00 7,500.00 3,725.00 2,895.99 17,120.99 Exterior Upgrades Complete sprinkler system Sod Trees Fence Energy efficient AC Total exterior upgrades $ $ $ $ $ $ 3,125.35 2,500.00 4,200.00 2,800.00 3,875.50 16,500.85 Lot Third acre $ 95,000.00 Total Estimated Cost $ 286,778.09 $ 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 $ 84.35 $ 158,156.25 Interior Upgrades Granite countertops Hardwood floors Tile floors in bathroom Kitchen appliances Total interior upgrades $ $ $ $ $ 3,000.00 7,500.00 3,725.00 2,895.99 17,120.99 Exterior Upgrades Complete sprinkler system Sod Trees Fence Energy efficient AC Total exterior upgrades $ $ $ $ $ $ 3,125.35 2,500.00 4,200.00 2,800.00 3,875.50 16,500.85 Lot Third acre $ 95,000.00 Total Estimated Cost $ 286,778.09 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 $ 84.35 $ 158,156.25 Interior Upgrades Granite countertops Hardwood floors Tile floors in bathroom Kitchen appliances Total interior upgrades $ $ $ $ $ 3,000.00 7,500.00 3,725.00 2,895.99 17,120.99 Exterior Upgrades Complete sprinkler system Sod Trees Fence Energy efficient AC Total exterior upgrades $ $ $ $ $ $ 3,125.35 2,500.00 4,200.00 2,800.00 3,875.50 16,500.85 Lot Third acre $ 95,000.00 Total Estimated Cost $ 286,778.09 $