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 04:30
Your take on decision making process
Answers: 1
question
Business, 22.06.2019 09:30
When you hire an independent contractor you don't have to pay the contractors what
Answers: 3
question
Business, 22.06.2019 20:00
Modern firms increasingly rely on other firms to supply goods and services instead of doing these tasks themselves. this increased level of is leading to increased emphasis on management.
Answers: 2
question
Business, 23.06.2019 02:10
Which of the following most accurately describes how the equilibrium price of a good or service can be determined? a. by moving the supply curve right or left until it matches the demand curve. b. by finding where the supply curve and the demand curve intersect. c. by doing market research to determine the maximum price consumers will pay. d. by taking the opposite of the columns in a supply schedule and a demand schedule.
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, 09.12.2019 11:31
question
Chemistry, 09.12.2019 11:31
question
Mathematics, 09.12.2019 11:31