Order from us for quality, customized work in due time of your choice.
In this assignment, you will need to use both Excel and Word.
Scenario:
You have landed your first job at your major company! Congrats! It’s Monday morning on your first day of the job and your boss wants you to create an Excel sheet with some new employees they hired on Friday and send them an Offer Letter showing them their current salary and projected salary after 1 year.
Example Scenario
Last Name First Name Address State Zip Code Current Salary Projected Salary Job Title
Stark Robert 67 Jarvis Lane CA 90011 $56,000 Jr. Analyst
Jackson Beth 78 Way St CA 91331 $78,000 VP Market Design
Stan Lee 56 West drive CA 94565 $58,970 Jr. Programmer
Task:
Create an Excel sheet with the provided data and make any corrections.
Create a formula for the 1-year salary increase of 5%
Create an offer letter and demonstrate the use of mail merge, filling in the proper fields
Employee Name
Employee Address
Current Salary
1-year salary projection
Job title
Company Name and address
Save your documents with the following name convention into your CSIT folder
1_firstinitallastname. xslx
1_firstintallastname.docx
2_firstintallastname.docx
OfferLetterEmployee_e.3_firstintallastname.docx
Upload your documents here. When turning in the documents please submit:
1. The Excel document with information and salary projections.
2. The original mail merge document (before the mail merge)
3. The mail merge document showing all of the letters
Order from us for quality, customized work in due time of your choice.