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

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

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 13 $101126 ChicgoMidwest Midwest Midwest Chicago Chicago Chicago Chicago New York Nework New York Midwest Northeast Northeast Northeast 24 $1115 25 $11116 27 11118 os Angeles 28 S11 Los Angeles 29 30 $12Los AsWest 31 1211 Los Angeles 32 121113Los Angeles 33 $121114 34 $121115 stetmLee eee West West s111120Los Angeles Boston Boston Boston Boston Boston Chicago ChicgoMidwest Chicago Chicago Chicago 35 $12116 36 $121 3 12118 Northeast Northeast Northcast Northeast Northeast 38 131111 33 S131112 1Midweat S13113Chiesgoidwest 41 $13114 Midwest 42 S131115 Midwect