see below

Office 2010 – myitlab:grader – Instructions Exploring Excel Ch. 10 - EOC

Proposed House Costs

Project Description: In this project, you will merge two workbooks together. After making some changes to the merged workbook, you will then accept or reject the changes made by each of the two authors. You will then remove the workbook from sharing, mark the workbook as final, and add your digital signature.

Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible 1 Start Excel. Download, save, and open the workbook named Exploring_e10_Grader_EOC.xlsx. 0 2 In the document properties, add Exploring Excel Student as a second author and Proposed House Costs as the title. Change the user name for Excel to Exploring Excel Student. 8 3 Add the Compare and Merge Workbooks button to the Quick Access Toolbar. Compare and merge the downloaded Excel file named Exploring_e10_Grader_EOC_to_merge into your open workbook. In the merged workbook, delete the Trees row from the worksheet. Change the Fence value in to $2,735.80, and then save the workbook. 8 4 Activate the Track Changes feature so that all changes by all users are highlighted on the screen. List all changes on a new sheet. Display the Select Changes to Accept or Reject dialog box and deselect all check boxes. Accept Anthony's first two changes: --Changed cell A6 from Estimated square footage to Main floor square footage. --Changed cell B6 from 3,400 to 1,875. done 8 5 Reject Anthony's change: --Changed cell B7 from $85.95 to $84.35. done 5 6 Accept Anthony's next three changes as follows: --Inserted row 14. --Changed cell A14 from <blank> to Kitchen appliances. --Changed cell B14 from <blank> to $2,895.99. done 8 7 Accept Anthony's next change: --Text in cell A25 from Third acre to Quarter acre. done 5 8 Accept your (Exploring Excel Student) change to delete row 20. Accept your change to the value in cell B20 from $2,800 to $2,735.80.DONE 8 9 Correct the formula in cell B15 so that it sums all interior upgrades. 10 10 Correct the formula in cell B22 so that it sums all exterior upgrades. 10 11 In cell B15, insert the comment Additional upgrades will increase the cost. (include the period). 10 12 Turn off workbook sharing and mark the workbook as final. 10 13 Create a digital certificate using the name Exploring Excel Student. Add a digital signature to your workbook using the certificate you create with To verify the sender as the purpose. 10 14 Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. 0 Total Points 100

Updated on: 2/2/2011 1 E_CH10_EXPV2_EOC_Instructions