B C D E E F G Instructions: A new sales training program has recently been created. The table to the right shows a list of salespeople within the company. Anyone making less than $100,000 in sales must participate. Use an IF statement to determine which salespeople need training. Write "Yes" if they have less than $100,000 in sales and "No" if they are making at least $100,000 in sales. After building out your IF Statement in cell FB, use the fill handle to fill in the remaining column. Hint: You will need to put the "Yes" and "No" in quotes Training Salesperson Noah Isabella Daniel Elizabeth Mia William Ethan Madison Henry Christian Scarlett Savannah Riley Levi Oliver Jack Luke Anna Austin Caroline Region North West South East North South West East East North West South South North East East West North South North $ S $ $ S S $ S S $ $ $ S S $ $ $ Sales 249,164.00 153,402.00 116,118.00 67,232.00 278,501.00 213,771.00 85,053.00 190,127.00 95,173.00 295,963.00 110,973.00 135,155.00 50,457.00 235,266.00 172,860.00 73, 126.00 233,444.00 123,400.00 274,685.00 172,893.00 aan Total Sales S 3,326,763.00