Office 2016 MyITLab MS-Excel Grader EX16_XL_CH11_GRADER_CAP_AS – Wedding Budget 1.1
: 0
  • Description

As a wedding planner, you prepared a wedding budget for a couple. It includes estimated and actual expenses. You will merge changes made by your assistant, use Track Changes, check for issues, add a signature line, and finalize the workbook.

Instructions:

For the purpose of grading the project you are required to perform the following tasks:

StepInstructionsPoints Possible
1Open Excel and enter your first name, middle initial, and last 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_a1_WeddingBudget.xlsx. Save it asexploring_e11_grader_a1_WeddingBudget_LastFirst.0.000
2Compare and merge exploring_e11_grader_a1_Karin.xlsx into your workbook.

Note, Mac users, on the Review tab, click Share Workbook. Ensure that the Allow changes by more than one user at the same time option is selected, and then click OK. From the Tools menu, click Merge Workbooks.

16.000
3Select cell A1. Activate the Track Changes feature, highlight all changes, click the When check box to deselect it, and then create a History worksheet. Select the data on the History worksheet, copy it to the Clipboard, add a new worksheet, and paste to keep source column widths. Rename the sheet Changes.

Note, Mac users, press COMMAND+SHIFT+4 and drag to capture the data on the History sheet. Click cell A1 on the Changes sheet, and then insert the saved image.

10.000
4On the Summary worksheet, open the Select Changes to Accept or Reject dialog box and deselect all check boxes.

Accept the changes to insert row 8; changes to cells A8, B8, C8, and D8. Reject the change to change Stationery to Stationary in cell A35. Accept the change to cells A1, B9, and C9. Accept changes to move B19:D20 to cells B20:D21 and the changes to cells B19, C19, and D19. Reject the change to cell C44. Accept all changes on the Changes worksheet. Turn off Shared Workbook.

13.000
5Run Document Inspector with all the default options selected. Click Remove All to remove elements detected by Document Inspector.0.000
6Insert the comment Review actual expenses. in cell D9 in the Summary worksheet (include the period).10.000
7Type Wedding Budget in the Title property box for the workbook. Type expenses in the Keywords property box.12.000
8Run Accessibility Checker. Make the two recommended changes in the Accessibility Checker pane.12.000
9Create 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 of each worksheet.15.000
10Display the Changes worksheet and select Landscape orientation, 0.2-inch left and right margins, and 90% scaling12.000
11Mark the workbook as final.0.000
12Save and close the workbook, and submit the file as directed.0.000
Total Points100.000

Leave a Reply