question archive Excel chapter 11 grader project Collaboration and Workbook Distribution Project Description: You are an assistant sales manager for a contractor who builds custom houses
Excel chapter 11 grader project Collaboration and Workbook Distribution Project Description: You are an assistant sales manager for a contractor who builds custom houses
Subject:MS ExcelPrice: Bought3
Excel chapter 11 grader project
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:
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 _HouseCosts.xlsx , and then save it as HouseCost_LastFirst replacing LastFirst with your name.
|
5 |
|
2. |
Compare and merge Anthony.xlsx into your workbook. Delete the Trees row, change the Fence value to $2,735.80 , and then save the workbook.
|
17 |
|
3. |
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 |
|
4. |
Insert a comment in cell B15 that Additional upgrades will increase the cost. (include the period).
|
8 |
|
5. |
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 |
|
6. |
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 |
|
7. |
Insert a footer with the sheet name code in the center, and the file name code on the right side.
|
5 |
|
8. |
Add a Microsoft Office Signature Line with the name Exploring Series Student .
|
7 |
|
9. |
Mark the workbook as final.
|
10 |
|
10. |
Save the file and close Excel. Submit the HouseCost_ LastFirst.xlsx file as directed.
|
0 |
Total Points 100
