E CH10 EXPV2 EOC Instructions
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 (do not open this file in Excel or you will not be able 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.
8
5
Reject Anthony's change:
--Changed cell B7 from $85.95 to $84.35.
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.
8
7
Accept Anthony's next change:
--Text in cell A25 from Third acre to Quarter acre.
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.
8
9
Correct the formula
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 (do not open this file in Excel or you will not be able 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.
8
5
Reject Anthony's change:
--Changed cell B7 from $85.95 to $84.35.
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.
8
7
Accept Anthony's next change:
--Text in cell A25 from Third acre to Quarter acre.
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.
8
9
Correct the formula