Question

1. Enter a function in cell I6 that determines the average salary of all full-time employees. Format the results in Accounting Number Format.

2.Click cell H10, and enter an AVERAGEIFS function to determine the average salary of full-time employees with at least one dependent. Format the results in Accounting Number Format.

Answer 1

To advise Peter, calculate the Net Annual Income by subtracting taxes from the gross salary, then divide by 12 for the monthly income. Compare this with monthly expenses to assess which job can cover costs and support his independence.

Step-by-step explanation:

Calculating Net Annual and Monthly Income for Job Positions

To calculate the Net Annual Income for each job position, one would subtract taxes and contributions for social security and medicare from the gross annual salary. Once the Net Annual Income is determined, you can divide this figure by 12 to obtain the monthly income. When advising Peter on the best job option, considerations should include the potential for career growth, educational requirements, and comparing the net income after expenses.

For instance, if Peter needs to cover monthly expenses, it's worth evaluating whether the salary from jobs like crew person at Mc Dowels, customer care representative, or financial analyst can adequately cover such expenses after tax deductions. Furthermore, advice for Peter on moving out would involve an analysis of his projected monthly expenses against the net monthly income from these potential job positions, taking into account the various tax obligations for each role.