Question

6. In the Accounting Professionals database, use Excel functions to find

a. the maximum number of years of service.

b. the average number of years of service,

c. the number of male employees in the database,

d. the number of female employees who have a CPA.

Answer 1

a. 35 years

b. 20 years

c. 525

d. 7

Step-by-step explanation:

The organization information provided is used to calculate the number of years of service of employee in the organization. The number of male employees are 525 and female employees are 120, among 120 only 7 female employees have done CPA.