ots) Solve the following problems by writing: 1. If a salesperson sells more than 100 units between March and May, they are eligible for a bonus. Given the spreadsheet below, 1 write an IF function that would output the 2 Person March April May Eligibility? term "eligible" if the sum of units sold by a3 X salesperson is greater than 100, and the term "ineligible" otherwise. Write the formula for person x in cell E3, and write it such that it can be dragged to the cells below (use static referencing) Units Sold 89 105 75 60 30 4 80