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 21:10
You own a nonunion company with 93 nonexempt employees. all of these employ- ees pack books into boxes for shipment to customers throughout the united states. because of wide differences in performance, you have decided to try performance appraisal, something never done before. until now, you have given every worker the same size increase. now you want to measure performance and reward the best performers with bigger increases. without any further information, which of the five types of appraisal formats do you think would be most appropriate? justify your answer. do you anticipate any complaints, or other comments, from employees after you implement your new system?
Answers: 1
question
Business, 22.06.2019 22:30
Which of the following situations is most likely to change a buyer's market into a seller's market? a. a natural disaster that drives away a lot of the population. b. the price of building materials suddenly going up. c. the government buys up a lot of houses to build a new freeway. d. a factory laying off a lot of workers in the area.
Answers: 1
question
Business, 23.06.2019 06:30
Afinance company wants to upgrade its accounting software to a higher version. this version change requires a change in data formats. which method represents a change in data formats?
Answers: 1
question
Business, 24.06.2019 02:00
In order to take advantage of the high quality talent pool, ernst & young sets up operations in the philippines and moves part of its tax services to its new facility. identify this strategy.
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
Chemistry, 08.07.2020 22:01
Questions on the website: 13722363