1. Enter a formula in cell E2 and copy down Col E to set the cell to YES for any employee whose sales were the highest in the company, and NO for all others. 2. Enter a formula in cell G4 to determine which territory had higher sales, Northeast or West. 3. Enter a formula in cell G5 to determine how many Top Sellers were from the New York Sales Office. 4. Enter a formula in cell G6 to determine how many Top Sellers were hired in 2010. The first character of the employee id is S for salespeople. The second and third characters indicate the year of hire. 5. In cell G7, write a formula to determine how many salespeople in the Chicago office were hired between 2012 and 2013. 6. In cell G8, write a formula to calculate the combined total sales of the New York and Chicago offices. 7. In cell G9, write a formula to determine how many salespeople from the Midwest territory, hired in 2013, had sales above $500,000. 8. In cell G10, write a formula to calculate the total sales for the lowest selling territory. 9. Enter a salesperson id in cell G12. Enter a formula in cell G13 to display the sales amount for the G12 employee. Your formula must work for any id number entered in G12. 10. Enter a formula in cell G14 to calculate the total sales for the G12 employee's sales office. Your formula must work for any id number entered in G12.

Salesperson ID Sales Office City Sales Office City Sales Territory 2020 Sales Company TOP Seller? S101111 New York Northeast 000000 S101112 New York Northeast 10000.00 S101113 New York Northeast 1500000 Which territory had higher sales, Northeast or West? How many Top Sellers were from the New York Sales Office? How many Top Sellers were hired in 2010? S101114 Los Angeles West 750000 S1011 Los Angeles West 925000 SIT116 Los Angeles West 600000 How many salespeople in the Chicago office were hired between 2012 and 20132 S101112 Los Angeles West 600000 Total combined sales for the New York and Chicago offices SI01118 Los Angeles West 1000000 How many Midwest salespeople hired in 2013 had sales above $500,000 S101119 Los Angeles West 1500000 Total sales for the lowest selling territory S101120 Boston Northeast 750000 S101121 Boston Northeast 925000 Enter Sales ID in G12 S101122 Boston Northeast 600000 Sales for the G12 employee Total Sales for the G12 employee's office S101123 Boston Northeast 600000 10000.00 STOI124 STO1125 STO126 S111111 S111112 S111113 S111114 SINIS S111116 S111117 SINIS SIT1119 SI11120 SI21111 S121112 SI21113 S121114 SI21115 S121116 S121117 SI21118 S131111 S131112 S131113 SI31114 S131115 S141111 S141112 S141113 S141114 S141115 S141116 S141117 S14111N S141119 S141120 S141121 Boston Boston Chicago Chicago Chicago Chicago Chicago New Yor! New York New York Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles Boston Boston Boston Boston Boston Chicago Chicago Chicago Chicago Chicago Chicago New York New York New York Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles Boston Northeast Northeast Midwest Midwest Midwest Midwest Midwest Northeast Northeast Northeast West West West West West West Northeast Northeast Northeast Northeast Northeast Midwest Midwest Midwest Midwest Midwest Midwest Northeast Northeast Northeast West West West West West West Northeast 400000 350000 800000 6000.00 600000 7500.00 1500000 750000 925000 600000 600000 1000000 15000.00 750000 925000 600000 600000 1000000 1500000 750000 925000 6000.00 0000 1000000 1500000 750000 925000 600000 600000 1000000 1500000 750000 9250.00 00000 800000 75000 Salesperson ID Sales Office City Sales Office City Sales Territory 2020 Sales Company TOP Seller? S101111 New York Northeast 000000 S101112 New York Northeast 10000.00 S101113 New York Northeast 1500000 Which territory had higher sales, Northeast or West? How many Top Sellers were from the New York Sales Office? How many Top Sellers were hired in 2010? S101114 Los Angeles West 750000 S1011 Los Angeles West 925000 SIT116 Los Angeles West 600000 How many salespeople in the Chicago office were hired between 2012 and 20132 S101112 Los Angeles West 600000 Total combined sales for the New York and Chicago offices SI01118 Los Angeles West 1000000 How many Midwest salespeople hired in 2013 had sales above $500,000 S101119 Los Angeles West 1500000 Total sales for the lowest selling territory S101120 Boston Northeast 750000 S101121 Boston Northeast 925000 Enter Sales ID in G12 S101122 Boston Northeast 600000 Sales for the G12 employee Total Sales for the G12 employee's office S101123 Boston Northeast 600000 10000.00 STOI124 STO1125 STO126 S111111 S111112 S111113 S111114 SINIS S111116 S111117 SINIS SIT1119 SI11120 SI21111 S121112 SI21113 S121114 SI21115 S121116 S121117 SI21118 S131111 S131112 S131113 SI31114 S131115 S141111 S141112 S141113 S141114 S141115 S141116 S141117 S14111N S141119 S141120 S141121 Boston Boston Chicago Chicago Chicago Chicago Chicago New Yor! New York New York Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles Boston Boston Boston Boston Boston Chicago Chicago Chicago Chicago Chicago Chicago New York New York New York Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles Boston Northeast Northeast Midwest Midwest Midwest Midwest Midwest Northeast Northeast Northeast West West West West West West Northeast Northeast Northeast Northeast Northeast Midwest Midwest Midwest Midwest Midwest Midwest Northeast Northeast Northeast West West West West West West Northeast 400000 350000 800000 6000.00 600000 7500.00 1500000 750000 925000 600000 600000 1000000 15000.00 750000 925000 600000 600000 1000000 1500000 750000 925000 6000.00 0000 1000000 1500000 750000 925000 600000 600000 1000000 1500000 750000 9250.00 00000 800000 75000