You are an assistant accountant in the Human Resources (HR) Department for Transpayne Filtration, a.


You are an ally accountant in the Human Resources (HR) Department for Transpayne Filtration, a union that sells soak filtration systems to residential customers. Transpayne has locations in Atlanta, Boston, and Chicago, delay a overseer at each location who oversees separate account representatives. You entertain an Excel workbook that contains names, locations, titles, employ dates, and salaries for the 20 overseers and account representatives. To plan for your upcoming remuneration analyses, you downloaded remuneration facts from the urbane factsbase into the workbook. The HR overseer wants you to achieve separate tasks inveterate on locations and job titles. You accomplish use logical functions to reckon annual benefit amounts and factsbase functions to help dissect the facts. Finally, you accomplish critique financial aspects of automobiles purchased for each overseer.