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)
Answers: 3
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
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
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
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
Step 1:In worksheet "Part2" there is a list of salespersons and their quarterly output. It is your j...
History, 08.07.2020 22:01
History, 08.07.2020 22:01
Mathematics, 08.07.2020 22:01
English, 08.07.2020 22:01
Chemistry, 08.07.2020 22:01
Chemistry, 08.07.2020 22:01