Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You have been asked by your boss to prepare a spreadsheet with contact information for all the employees in your department. The Information she
You have been asked by your boss to prepare a spreadsheet with contact information for all the employees in your department. The Information she is looking for is: Employee Number (Four or more digits) Last Name First Name Job Title Hire Date Telephone Number Address City State Zip Code Prepare a worksheet with the above information for a minimum of five fictitious employees. Make sure to include the following formatting specifications: A title that is Calibri 14 pt. and centered over your data rows. Column headings that are Calibri 12 pt. and are rotated on an angle. Cells formatted appropriately (dates, text. Bordering and coloring for a professional look Add a filter to each column so they can be sorted by your boss. Have them in order according to their employee number. The screenshot below shows an example with two employees. Empinyon Contact List Lost Talli First Name *Job Title Hire Date Telephone Number Address City State Zip Code Prepare a worksheet with the above information for a minimum of five fictitious employees. Make sure to include the following formatting specifications: A title that is Calibri 14 pt. and centered over your data rows. Column headings that are Calibri 12 pt. and are rotated on an angle, Cells formatted appropriately (dates, text). Bordering and coloring for a professional look. Add a filter to each column so they can be sorted by your boss. Have them in order according to their employee number. The screenshot below shows an example with two employees. I Employee Number 1235 Smith 1236 White Sandra Etien Last Name Grst Name Job Title NOT Employee Contact Ust Hire Date Telephone Nonsber Address 4/2/2014 555-123-4554 10 Barclay Dr Des Plaines L Help Desk Adminstrative Assistant 11/23/2019 555-123-4433 15 Norman Rd Des Plaines 60016 60016 in her Help, Both kinds of tutoring can
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started