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

pur-new-sol

Purchase A New Answer

Custom new solution created by our subject matter experts

GET A QUOTE