Salary Year-End Bonus $49,712 Title First Name Last Name Location Amy Bonnie Carol Danny Emma Moore Boston Account Rep $49,749 Fiona Greg Hanna lan Johnson Chicago Account Rep $65,214 Joseph Kate Larry $527.09 $6,984.24 $10,649.63 $2,470.12 $3,419.19 $13,305.34 $7,794.33 $236.73 $456.93 $3,037.37 $15,840.63 $0.00 Trainee Smith White Lee Hill Atlanta Atlanta Account Rep $101,348 Atlanta Boston $155,150 $98,823 Manager Account Rep Clark Watson Boudreau Chicago Account Rep $71,518 $71,639 $51,276 Boston Account Rep Boston Manager Cooper Straub Davidson Miami $74,168 $99,094 94,620 Chicago Account Rep Chicago Manager Manager 3. Filtering a Table with Advanced-Filter Remove all AutoFilter from the Employee list. a) Use Advanced Filter to generate a list of all employees from Atlanta earning salary more than $50,000. This requires you to first set up a criteria range. Select the Action option "Filter the list, in-place. b) Use Advanced Filter to generate a list of all Managers, plus employees from Atlanta earning salary more than $50,000. This requires you to first set up a criteria range. Filter the results to another location