Computer scienec projet E11
steve_92
e_ch11_expv2_h1.zipE_CH11_EXPV2_H1_Instructions.docx
Office 2013 – myitlab:grader – Instructions Exploring Series Vol. 2
Collaboration and Workbook Distribution
Project Description: You have been hired as an assistant accountant for a small health care IT company. Your role is to merge monthly financial documents from multiple locations, check compatibility, and, after management approval, finalize and distribute your results.
Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible 1 Open Excel and enter your name as the user name in the Excel Options dialog box, if necessary. Add the Compare and Merge Workbooks command to the Quick Access Toolbar, if necessary. Download and open exploring_e11_grader_h1.xlsx and save it as e11c1HealthCare_LastFirst, replace LastFirst with your last name. 0 2 Display the Backstage view and add Exploring Series Student as an Author and Grader 1 as the Title. 12 3 Compare and merge e11c1Dallas.xlsx and e11c1Atlanta.xlsx into your workbook. 12 4 Click cell B13, type $100,250 to reflect a last-minute addition of $10,000 in sales, and then save the workbook. 6 5 Activate the Track Changes feature, highlight all changes, and then create a History worksheet. Open the Select Changes to Accept or Reject dialog box and deselect all check boxes. Accept all changes and turn off workbook sharing. 16 6 Run the Accessibility Checker, identify potential problems, and then fix the warning issues detected. Close the Accessibility Checker task pane. Hint: Click the FILE tab. On the Info page, click Check for Issues. To fix the issues, unmerge the cells in the range A1:E1. 8 7 Run the Compatibility Checker, correct any significant loss of fidelity issues, and ignore any minor loss of fidelity issues. 8 8 Insert a footer with the sheet name code in the center, and the file name code on the right side. 12 9 Add a signature line with the name Exploring Series Student. 12 10 Mark the workbook as final. 14 11 Save the file and close Excel. Submit the e11c1HealthCare_LastFirst.xlsx file as directed. 0 Total Points 100
Updated: 08/23/2013 1 E_CH11_EXPV2_H1_Instructions.docx
exploring_e11_grader_h1.xlsx
Summary
| Sales Summary | ||||
| Dallas Total Sales | Dallas Total Expenses | |||
| Qtr 1 | $ 85,000.00 | Qtr 1 | $ 22,121.00 | |
| Qtr 2 | $ 45,000.00 | Qtr 2 | $ 12,250.00 | |
| Qtr 3 | $ 35,000.00 | Qtr 3 | $ 17,582.00 | |
| Qtr 4 | $ 84,510.00 | Qtr 4 | $ 10,787.00 | |
| Subtotal | $ 249,510.00 | Subtotal | $ 62,740.00 | |
| Atlanta Total Sales | Atlanta Total Expenses | |||
| Qtr 1 | $ 67,000.00 | Qtr 1 | $ 12,545.00 | |
| Qtr 2 | $ 45,250.00 | Qtr 2 | $ 14,765.00 | |
| Qtr 3 | $ 28,452.00 | Qtr 3 | $ 10,212.00 | |
| Qtr 4 | $ 90,250.00 | Qtr 4 | $ 9,785.00 | |
| Subtotal | $ 230,952.00 | Subtotal | $ 47,307.00 | |
| Grand Totals | ||||
| Total expenses | $ 110,047.00 | |||
| Total Sales | $ 480,462.00 | |||
| Net Profit | $ 370,415.00 | |||
e11c1Atlanta.xlsx
Summary
| Sales Summary | ||||
| Dallas Total Sales | Dallas Total Expenses | |||
| Qtr 1 | $ 85,000.00 | Qtr 1 | $ 22,121.00 | |
| Qtr 2 | $ 45,000.00 | Qtr 2 | $ 12,250.00 | |
| Qtr 3 | $ 35,000.00 | Qtr 3 | $ 17,582.00 | |
| Qtr 4 | $ 84,510.00 | Qtr 4 | $ 10,787.00 | |
| Subtotal | $ 249,510.00 | Subtotal | $ 62,740.00 | |
| Atlanta Total Sales | Atlanta Total Expenses | |||
| Qtr 1 | $ 72,000.00 | Qtr 1 | $ 5,890.00 | |
| Qtr 2 | $ 45,250.00 | Qtr 2 | $ 14,765.00 | |
| Qtr 3 | $ 31,000.00 | Qtr 3 | $ 12,545.00 | |
| Qtr 4 | $ 90,250.00 | Qtr 4 | $ 9,785.00 | |
| Subtotal | $ 238,500.00 | Subtotal | $ 42,985.00 | |
| Grand Totals | ||||
| Total expenses | $ 105,725.00 | |||
| Total Sales | $ 488,010.00 | |||
| Net Profit | $ 382,285.00 | |||
e11c1Dallas.xlsx
Summary
| Sales Summary | ||||
| Dallas Total Sales | Dallas Total Expenses | |||
| Qtr 1 | $ 85,000.00 | Qtr 1 | $ 22,121.00 | |
| Qtr 2 | $ 45,000.00 | Qtr 2 | $ 12,250.00 | |
| Qtr 3 | $ 35,000.00 | Qtr 3 | $ 17,582.00 | |
| Qtr 4 | $ 87,513.00 | Qtr 4 | $ 12,985.00 | |
| Subtotal | $ 252,513.00 | Subtotal | $ 64,938.00 | |
| Atlanta Total Sales | Atlanta Total Expenses | |||
| Qtr 1 | $ 67,000.00 | Qtr 1 | $ 12,545.00 | |
| Qtr 2 | $ 45,250.00 | Qtr 2 | $ 14,765.00 | |
| Qtr 3 | $ 28,452.00 | Qtr 3 | $ 10,212.00 | |
| Qtr 4 | $ 90,250.00 | Qtr 4 | $ 9,785.00 | |
| Subtotal | $ 230,952.00 | Subtotal | $ 47,307.00 | |
| Grand Totals | ||||
| Total expenses | $ 112,245.00 | |||
| Total Sales | $ 483,465.00 | |||
| Net Profit | $ 371,220.00 | |||
