Question: There are 741 records in this sheet. Complete the sheet by follow the instructions: - [2 pts] Format it as table - [5 pts] Add

There are 741 records in this sheet. Complete the

There are 741 records in this sheet. Complete the sheet by follow the instructions: - [2 pts] Format it as table - [5 pts] Add a column to calucate the number of years they have worked - [5 pts] Add a colume called "Bonus". The bonus is based on years of work and calculated: (do not use nested ifs) 10%:25 years or more 5%:1025 years 2% lesss than 10 years - Conditional formatting: - [5 pts] Highlight the name of those that have worked more than 25 years - [5 pts] Highlight the salary of those that are making above average - [5 pts] Bold the name of those that are full time employees - [5 pts] Underline and change the text color of employee that has been working the longest - [3 pts] In L11, create a list of the employee names - [15 pts] Display the following message for the selected employee: (example is for Garrentt, Chris)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!