subject
Business, 22.04.2021 21:30 lesmontoya10

Step 1:In worksheet "Part2" there is a list of salespersons and their quarterly output. It is your job to assess the data for anyone who receives a bonus. Employees get a 10% bonus of their total sales if they have total annual sales above $10,000. Employees also get a quarterly bonus of 3% if a single quarters sale is above $3,000. You are to use conditional formatting to: i) If an employee gets a quarterly bonus, the quarter in which they received the bonus, should be highlighted light yellow. ii) If an employee gets an annual bonus the Total column should be highlighted light green ii) The top 10% of total earning employees should be marked with a greed dot icon in their total column. You must use conditional formatting to complete these tasks. EIN 3354 Eng. Econ. 2 Step 2: There is also a column for when each person turned in their sales report. You are to use conditional formatting such that if the user turned in their report after 12/17/2020 a red icon with an X is placed in the cell, and if they turned it in on or before 12/17/2020 a green icon with a check is placed in that cell. (10 points)

ansver
Answers: 3

Another question on Business

question
Business, 22.06.2019 08:30
Most angel investors expect a return on investment of question options: 20% to 25% over 5 years. 15% to 20% over 5 years. 75% over 10 years. 100% over 5 years.
Answers: 1
question
Business, 22.06.2019 08:30
Conor is 21 years old and just started working after college. he has opened a retirement account that pays 2.5% interest compounded monthly. he plans on making monthly deposits of $200. how much will he have in the account when he reaches 591 years of age?
Answers: 2
question
Business, 22.06.2019 11:00
Zoe would like to be able to save for night courses at the local college. which of these would be a good way for zoe to make more money available for savings without dramatically changing her budget? economía
Answers: 2
question
Business, 22.06.2019 15:30
Uknow what i love about i ask a dumb question it is immediately answered but when i ask a real question it take like an hour to get answered
Answers: 2
You know the right answer?
Step 1:In worksheet "Part2" there is a list of salespersons and their quarterly output. It is your j...
Questions
question
Mathematics, 24.02.2021 21:50
question
Mathematics, 24.02.2021 21:50
question
Mathematics, 24.02.2021 21:50
Questions on the website: 13722363