+
Exploring Series Vol. 2 Collaboration and Workbook Distribution

Exploring Series Vol. 2 Collaboration and Workbook Distribution

Rating:
Rating
(0)
Author: matthew stock
Description:

http://homework.plus/exploring-series-vol-2-collaboration-and-workbook-distribution/

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 openexploring_e11_grader_h1.xlsx and save it ase11c1HealthCare_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.xlsxintoyour 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


(more)
See More
Try a College Course Free

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

Begin Free Trial
No credit card required

25 Sophia partners guarantee credit transfer.

221 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 20 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.

Tutorial