The College of Science at Prestige University hosts a lecture series of guest presenters in the…

The College of Science at Prestige University hosts a lecture series of guest presenters in the industry. As the administrative assistant, you are responsible for maintaining the budget, which includes the following expenses: lunches for the speakers and select faculty, printing costs for bulletin board fliers, travel accommodations for one out-of-state presenter per semester, and a gift pen set for each speaker. Your predecessor created a workbook containing expenses for the 2012–2013 academic year; however, it contains errors. You and the associate dean, Samantha Young, will review and correct the workbook. Then, you will merge the two workbooks and accept and reject changes as needed. In addition, you need to prepare the workbook for distribution to the university’s budget office.

a. Open e10m2lecture, and then save it as e10m2lecture_LastnameFirstname.

b. Make sure your name is the user name in the Excel Options dialog box.

c. Add the Compare and Merge Workbooks command to the Quick Access Toolbar, if necessary. Compare and merge e10m2samantha with your workbook.

d. Make the following changes in the workbook:

e. Insert the following comment in cell C13 in the Spring worksheet: The 2012–2013 budget was $5,000, so we didn’t have a deficit. However, we need to trim at least $225 from next year’s expenses.

f. Activate the Change Tracking feature so that you can accept and reject changes. Accept and reject these changes:

g. Edit your comment in cell C13 in the Spring sheet by typing Updated cut cost: $120 at the end of the existing comment.

h. Create a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side on each worksheet.

i. Edit cell A10 in the Travel sheet: Spring 2013, and then make the semesters specific, such as 2012 and 2013, in cells A1 and A6 in the Gifts sheet.

j. Run Accessibility Checker. Ignore any warnings about merged cells, and then close the Accessibility Checker task pane.

k. Create a Windows Live account if you do not already have one. Create a folder on your SkyDrive, and then name it Exploring. Enter your instructor’s e-mail address so that you can share that folder with your instructor.

l. Save the workbook to the Exploring folder on your SkyDrive.

m. Save and close the workbook, and submit based on your instructor’s directions.