Sunlight Computing wants to give each member of the sales team a small gift to honor his/her performance over the past year. The HR Manager gives her analyst the spreadsheet on the left that has the employee number of each employee and the employee's contribution to sales. She asks the analyst to fill in the Gift column with an indication of the type of gift to be given to the employee according to the following scheme:

If an employee's contribution is less than $22,000, he/she gets a pen with the Sunlight logo on it.

If an employee's contribution is between $22,000 and $64,000, the employee gets a money clip with the Midnight logo.

If an employee's contribution is between $64,000 and $106,000, the employee gets a large mug.

Contributions of $106,000 or more are to be recognized with a plaque.

According to the above, enter in column C the appropriate gift to be awarded to each employee, i.e., enter Pen, Clip, Mug or Plaque

 

Transcribed Image Text:

Employee # Contribution to Sales 51333 $ 2917 $ 31966 $ 5167 $ 92686 $ 72688 $ 52585 $ 25488 $ 91134 $ 1554 $ 51155 $ 37,812 123,341 46,712 116,381 41,226 39,989 63,300 38,908 91,375 100,763 96,241 15977 $ 81,472 13516 $ 55,613 97516 $ 105,751 47108 $ 21,810 45905 $ 62,653 3524 $ 77,505 38185 $ 67,729 88312 $ 78,342 87961 $ 7,600 52240 $ 125,987 48888 $ 26,322 36374 $ 94,319 90321 $ 23,692 97178 $ 17,882 24748 $ 65,024 88867 $ 97914 $ 3887 $ 93424 $ 92327 $ 87162 $ 56695 $ 11642 $ 43008 $ 65620 $ 88274 $ 14679 $ 62368 $ 28,351 92,483 93,025 124,560 92,255 40,228 71,673 62,652 13,331 29,898 5,083 103,394 108,678 Gift Employee # Contribution to Sales 51333 $ 2917 $ 31966 $ 5167 $ 92686 $ 72688 $ 52585 $ 25488 $ 91134 $ 1554 $ 51155 $ 37,812 123,341 46,712 116,381 41,226 39,989 63,300 38,908 91,375 100,763 96,241 15977 $ 81,472 13516 $ 55,613 97516 $ 105,751 47108 $ 21,810 45905 $ 62,653 3524 $ 77,505 38185 $ 67,729 88312 $ 78,342 87961 $ 7,600 52240 $ 125,987 48888 $ 26,322 36374 $ 94,319 90321 $ 23,692 97178 $ 17,882 24748 $ 65,024 88867 $ 97914 $ 3887 $ 93424 $ 92327 $ 87162 $ 56695 $ 11642 $ 43008 $ 65620 $ 88274 $ 14679 $ 62368 $ 28,351 92,483 93,025 124,560 92,255 40,228 71,673 62,652 13,331 29,898 5,083 103,394 108,678 Gift

Answer rating: 100% (QA)

If function in exce... View the full answer