Office 2013 MyItLab Grader Instructions Exploring Series

Office 2013 – myitlab:grader – Instructions Exploring Series Vol. 2 Collaboration and Workbook Distribution Project

You are an assistant sales manager for a contractor who builds custom houses. Your job is to prepare initial estimates for people who want to purchase a lot and build a house in the development community. As you prepare plans, you get feedback from the office manager, incorporate changes, and finalize the workbook to distribute to potential buyers.

For the purpose of grading the project you are required to perform specific tasks in Excel, including customizing options, comparing workbooks, tracking changes, inserting comments, running accessibility and compatibility checks, adding headers and footers, inserting a signature line, marking the workbook as final, and saving and submitting the file.

Paper For Above instruction

The project involves working with an Excel workbook that estimates proposed house costs for clients Jon and Jen Patterson. The task requires detailed data entry, workbook comparison, change tracking, commenting, accessibility and compatibility checking, and proper document finalization procedures in Microsoft Excel 2013.

Initially, the task requires customizing Excel settings by adding commands such as E-mail and Compare and Merge Workbooks to the Quick Access Toolbar, and saving the workbook under a specific name that includes your last and first name. The next step involves setting document properties by adding author and title information to the backstage view, which helps in maintaining document metadata.

Subsequently, the user must compare and merge data from another workbook, delete unnecessary rows, modify values such as the Fence cost, and save the updates. The process then continues with activating change tracking, highlighting changes, creating a history worksheet, and accepting or rejecting specific changes, which is essential for version control and review.

Comment insertion follows, where notes are added into specific cells regarding upgrades and market conditions affecting costs. Completing these comments ensures clear communication within the team and clients. After that, the user must turn off workbook sharing and run accessibility and compatibility checkers to identify and fix potential issues, ensuring the workbook meets standards for users with disabilities and compatibility with different versions of Excel.

Inserting a footer with the sheet name centered and the file name on the right side ensures proper document identification when printed or viewed as a PDF. Adding a Microsoft Office Signature Line provides a formal verification method, indicating approval or review of the workbook. Marking the workbook as final signifies that the document is ready for distribution, reducing unintended edits.

Finally, saving the completed workbook and closing Excel fulfills the project requirements, with the file then submitted as directed. Throughout this process, accurate data entry, meticulous attention to detail, and adherence to these instructions are crucial for successful completion and grading of the project.

References

• Microsoft Corporation. (2013). Microsoft Office Excel 2013 Inside Out. Microsoft Press.
• Gaskins, A. (2019). Mastering Excel for Data Analysis and Visualization. Sage Publications.
• Walkenbach, J. (2013). Excel 2013 Bible. Wiley.
• Chang, R. (2014). Excel Data Analysis: Your visual blueprint for analyzing data, charts, and PivotTables. Wiley.
• Resnick, J. & Love, J. (2016). Excel VBA Programming For Dummies. Wiley.
• U.S. Department of Education. (2020). Accessibility Guidelines for Microsoft Office Applications. U.S. Government Printing Office.
• Microsoft Support. (2013). Accessibility Checker overview in Excel. Microsoft Support.
• Microsoft Support. (2013). Compatibility Checker in Excel 2013. Microsoft Support.
• Garrett, E. (2015). Effective Workbook Management in Excel. O'Reilly Media.
• O'Neil, P. (2017). Excel for Project Managers. Packt Publishing.