Question: 1 ) I cannot upload everything in one page so I separated it. Here is the question what I want to get based on this
1 ) I cannot upload everything in one page so I separated it. Here is the question what I want to get based on this excel sheet.
https://www.chegg.com/homework-help/questions-and-answers/3-question-excel-2016-17-firm-employed-68-salespeople-attached-spreadsheet-provides-inform-q43911578?trackid=PzSbViUn
| SALESPERSON | 2016 SALES TARGET | 2016 NEW CLIENTS | 2016 NEW SALES |
| Almeida | 215000 | 15 | 212723 |
| Anderson | 170000 | 16 | 171616 |
| Ball | 155000 | 13 | 153201 |
| Ballestero | 125000 | 12 | 124904 |
| Barrio | 215000 | 15 | 213756 |
| Billimoria | 65000 | 5 | 66519 |
| Budge | 185000 | 14 | 183450 |
| Cohen | 95000 | 10 | 96370 |
| Curtin | 185000 | 15 | 183008 |
| Drew | 185000 | 12 | 186783 |
| Fiennes | 200000 | 10 | 199473 |
| Florio | 230000 | 13 | 231519 |
| Fondue | 155000 | 13 | 156292 |
| Francis | 35000 | 6 | 36918 |
| Geddes | 65000 | 6 | 66014 |
| Godden | 80000 | 13 | 78573 |
| Goetz | 50000 | 4 | 47933 |
| Halls | 140000 | 7 | 140367 |
| Harris | 50000 | 4 | 51523 |
| Houtz | 20000 | 1 | 20902 |
| Ignatius | 170000 | 8 | 170816 |
| Inada | 80000 | 12 | 79217 |
| Ismail | 230000 | 16 | 232449 |
| Issa | 155000 | 8 | 156275 |
| Jackson | 200000 | 12 | 202145 |
| James | 170000 | 10 | 168575 |
| Jarvis | 35000 | 7 | 36789 |
| Johnson | 140000 | 13 | 141473 |
| Kakar | 170000 | 10 | 169756 |
| Keay | 80000 | 7 | 79283 |
| Kemp | 155000 | 7 | 153711 |
| Kennedy | 230000 | 16 | 231776 |
| Kingston | 50000 | 2 | 48176 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
