MFCL Bonuses - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VMEW . .

Question

MFCL Bonuses - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VMEW . . A Conditional Formatting Format as Table insert Delete FormatFilter Cells Calibri Paste Sort , Cell Styles. Clipboard Font Alignment Number Styles Edit E4 Marble Falls Community Library Bonuses Performance Ratin Last Name 4 Walker 5 Benet 6 Buescher 7 Caldwell 8 Gomez 9 Lopez 10 Lorne 11 Middleton 12 Wachter 13 Walters 14 White 15 16 First Name Ken ason David Jack Current Sala Bonus 12,408.00 8,696.00 10,480.00 11,480.00 $14,560.00 $ 31,616.00 3,800.00 12,000.00 17,000.00 25,000.00 $ 18,000.00 Maria Tyler Gary Tyronne Bonus Calculation Lookup Table Show Task List O Task: EX4608 Question 6 of 10 Time Remaining: No Limit Att Norton Intern

Explanation / Answer

After scattering perfomance index as the way it was given in the question, we can say that, bonus figure will come as folllows as table use values as given and we will arrive at bonus given.

Bonuses Last name First Name Current salary Perfomance rating Bonus Walker ken $      12,408.00 3 $               5.00 Benet Jason $        8,696.00 5 $               2.00 buesher david $      10,490.00 4 $               2.00 caldwell jack $      11,480.00 2 $               3.00 gomez grace $      14,560.00 3 $               5.00 lopez amy $      31,616.00 5 $               2.00 lorne dora $        3,800.00 5 $               2.00 middleton maria $      12,000.00 2 $               3.00 watcher tyler $      17,000.00 2 $               3.00 walters gary $      25,000.00 3 $               5.00 white tyronne $      10,000.00 3 $               5.00 3 5 4 2 3 5 5 2 2 3 3

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.