Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Clipboard E Font EN X Alignment Number Styles Performance 2022 Salary 2022 Bonus A D B D F H Last Name First Name Gender

image text in transcribed

Clipboard E Font EN X Alignment Number Styles Performance 2022 Salary 2022 Bonus A D B D F H Last Name First Name Gender Department Title 2021 Salary 000 Aikman Gary F Sound Design Senior Sound Designer $ 67,000 Average 387 Felser Cynthia F Animation Lead Animator $ 80,000 Good 552 Leslie 936 Cusak Jean F Art Artist $ 45,250 Average Barbara F Programming Programmer $ 70,125 Average 048 Noble Linda M Game Design Senior Game Designer $ 72,500 Excellent 309 Bobbitt Oronzo F Programming Senior Programmer $ 105,250 Good 390 Lobree Cindy F Art Artist $ 46,125 Average 447 Sampieri Maylou M Programming Programmer $ 61,000 Good 828 Powell Kathy F Quality Assurance QA Tester $ 45,000 Excellent M Raise Amount Average Good 1% 2% Excellent 4% Bonus Enhanced bo $500 $1,250 Filter Select Cells Editing Use the Raise table to calculate employees' 2022 Salary amount If the employee is in the Quality Assurance departments and their performance rating is good, they will receive the enhanced bonus amount. Everyone else should be paid $500 O P 5 2080 Cole Kordell M Programming Programmer $ 65,100 Average 5 182 Foerster 392 Guilford Shelly Betty 2524 Drubin Hank 155 F Animation Senior Animator $ 51,250 Average Use Conditional formatting to highlight the names of those eligible for the Enhanced Bonus 2 F Animation Animator $ 58,000 Good + F Programming Programmer $ 68,750 Good 593 Spinale Lorna M Sound Design Sound Designer $ 61,250 Excellent 2961 Watson Fran F Programming Programmer $ 85,750 Excellent 153 Pennekamp Lynn F Quality Assurance Senior QA Tester $ 51,000 Excellent 3183 Fegin Nancy M Programming Programmer $ 89,000 Excellent 8638 Erpf Meredith F Programming Programmer $ 85,800 Excellent 3694 White Jack F Programming Programmer $ 89,000 Excellent 3703 Jones Maryanne F Art Senior Artist $ 65,800 Good 8949 Jackson. Heidi F Art Senior Artist $ 59,850 Average 1196 Hood Joan F Art Senior Artist $ 65,000 Good 1426 Moss Lance F Art Artist $ 52,250 Excellent 5271 Wilson Claudia M Animation Animator $ 40,000 Average 5594 Ross Fred F Quality Assurance QA Tester $ 35,000 Average 5696 Martin Patsy F Art Artist $ 45,000 Average 5881 Scott Laura M Animation Animator $ 50,000 Average 5903 Park Ryan M Game Design Game Designer. 57,250 Good 5213 Gonzalez Yolanda F Animation Animator 61,250 Excellent 5401 Wynperle Allison M Art Senior Artist 70,000 Good Salan Sheet4 Loan Amount

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamental Accounting Principles

Authors: John Wild, Ken Shaw, Barbara Chiappetta

22nd edition

9781259566905, 978-0-07-76328, 77862279, 1259566900, 0-07-763289-3, 978-0077862275

More Books

Students also viewed these Accounting questions

Question

Who acted ethically in the American Food Suppliers scandal

Answered: 1 week ago