1. Write a formula in cell E4 that uses a nested IF to set the cell value based on sales for 2018:

High if sales are >=1500000

Moderate if sales are >= 1000000 but

Low for all others

Copy the formula down col E.

2. Write a formula in cell F4 that uses a vlookup with the table in cells I4 through J6 to set the cell value based on sales for 2018:

High if sales are >=1500000

Moderate if sales are >=1000000 but

Low for all others

Copy the formula down col F.

3. In cell H7, write a formula to determine how many salespeople had high sales in 2018.
4. In cell H8, write a formula to determine how many salespeople from the Northeast Territory had high sales in 2018.
5. In cell H9, write a formula to determine the total sales for the West territory for 2018.
6. In cell H10, write a formula to determine how many total employees from the Boston and Chicago offices had low sales.
7. In cell H11, write a formula to calculate the average sales per sales rep for 2018.

9. In cell H12, write a formula to calculate the average sales for reps from the West territory for 2018.

10. In cell H13, write a formula to determine which Region had lower sales for 2018, West or Northeast.

11. In cell H14, write a formula to determine how many salespeoples IDs begin with S12.

12. Enter an employee id in cell G17. In cell H17, write a formula to determine which sales region the employee from G17 is assigned to.

H3 lesperson's l:ales Office Citales Territor 2018 Sal Sales Category Sales Categ 3 Sales A oSales Category 0 LOw 000000 MODERATE $101111 Nework Nework New Yorlk Los Angeles 600000 heast 1000000 Northeat 1500000 50000 Northeast Nort 500000 HIGH High Sales for 2018 High Sales for 2018 (Northeast Territory) Total Sales for 2018 for West territory Low Sales from Boston and Chicago Offices Average sales for all sales reps 2018 Average sales for West territory sales reps Which Region had lower sales for 2018, West or Northeast? Sales IDs beginning with S12 $101114 west $101115 Los Angeles West $101116 Los Angeles West S101117 Los Angeles West Los Angeles West Los Angeles West Boston Northeast 14 S101121 Boston Boston Boston Boston Boston Northeast Northeast Northeast Nort 600000 Enter Sales ID in G17 S101124 heast 1000000 $1011 Sheet1 READY 3 alesperso's ales Office Citales Territor 2018 Sal S101111 Nework Nework Nework Los Angeles Northeast Northeat 1000000 Northeast 1500000 S101113 Wect Los Angeles West Los Angeles Wect S101117 Los Angeles West S101118 Los Angeles West S101113 Los Angeles West Boston Northeast Boston Boston Boston Boston Boston Northeast Northeast Northeast Northeat 1000000 Mid S101123 $101124 Sheet1 | READY