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 11:30
You've arrived at the pecan shellers conferenceβ€”your first networking opportunity. naturally, you're feeling nervous, but to avoid seeming insecure or uncertain, you've decided to a. speak a little louder than you would normally. b. talk on your cell phone as you walk around. c. hold an empowered image of yourself in your mind. d. square your shoulders before entering the room.
Answers: 2
question
Business, 22.06.2019 13:50
Diamond motor car company produces some of the most luxurious and expensive cars in the world. typically, only a single dealership is authorized to sell its cars in certain major cities. in less populous areas, diamond authorizes a single dealer for an entire state or region. the manufacturer of diamond automobiles is using a(n) distribution strategy for its product.
Answers: 2
question
Business, 22.06.2019 16:20
The assumptions of the production order quantity model are met in a situation where annual demand is 3650 units, setup cost is $50, holding cost is $12 per unit per year, the daily demand rate is 10 and the daily production rate is 100. the production order quantity for this problem is approximately:
Answers: 1
question
Business, 22.06.2019 19:30
Which of the following businesses is most likely to disrupt an existing industry? a. closer connex developed an earphone that receives emails and text messages and converts them to voice messages. the first models had poor reception, but they rapidly improved over time. b. mega technologies reconfigured the components used in its touchscreen tablets to create a new type of wearable device for use in restaurants and other service industries. c. particle inc. developed a teleportation technology that can transport physical materials instantaneously across great distances. d. altrea added advanced camera technology to its premium line of smartphones so that they would take the highest-quality photos of all phones on the market.
Answers: 1
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, 03.08.2019 04:00
question
History, 03.08.2019 04:00
question
Mathematics, 03.08.2019 04:00
Questions on the website: 13722360