8. Write a formula in cell 'Salary Averages by Department'!E3, which can be copied down to 'Salary Averages by Department'!E7, to calculate the average salary by department and by salary range for all salaries >=$65,000. Again, because there will be multiple criteria for this formula, you must use the AVERAGEIFS function, but the arguments will not be the same as the previous formula. The arguments for this function will be as follows. (Use cell references for all ranges and criterion.) Average Range: Employee's salary Range1: Employee's salary Range Criteria1: > =65000 Range2: Departments Range Criteria2: Department A B C D E F ating Scale: Poor: 4 Fair: 3 Good: 2 Excellent: 1 \begin{tabular}{r|l|c|c|c|c} \hline iployee \# & Department & Salary & Question 1 & Question 2 & Question 3 \\ \hline 42534 & Human Resources & $36,905 & 3 & 1 & 2 \\ \hline 59031 & Customer Service & $42,531 & 2 & 3 & 3 \\ \hline 59044 & Human Resources & $74,078 & 4 & 4 & 1 \\ \hline 52098 & Information Technology & $47,758 & 1 & 3 & 1 \\ \hline 46520 & Underwriting & $76,679 & 1 & 4 & 2 \\ \hline 56714 & Accounting & $66,647 & 4 & 3 & 3 \\ \hline 31533 & Accounting & $36,700 & 2 & 3 & 1 \\ \hline 56831 & Accounting & $78,764 & 1 & 2 & 4 \\ \hline 57441 & Human Resources & $75,940 & 1 & 3 & 2 \\ \hline 46184 & Accounting & $71,723 & 1 & 1 & 1 \\ \hline 53170 & Information Technology & $37,038 & 3 & 4 & 2 \\ \hline 52348 & Accounting & $35,804 & 1 & 1 & 4 \\ \hline 31286 & Customer Service & $54,583 & 1 & 3 & 4 \\ \hline 50128 & Underwriting & $67,099 & 3 & 4 & 3 \\ \hline 49701 & Customer Service & $44,594 & 2 & 3 & 2 \\ \hline 49163 & Information Technology & $77,092 & 4 & 3 & 3 \\ \hline 50149 & Underwriting & $46,447 & 1 & 2 & 3 \\ \hline 35485 & Human Resources & $57,068 & 3 & 3 & 1 \\ \hline 32595 & Customer Service & $71,354 & 4 & 2 & 4 \\ \hline 54127 & Customer Service & $66,717 & 4 & 4 & 3 \\ \hline & & & & & \\ \hline \end{tabular} 8. Write a formula in cell 'Salary Averages by Department'!E3, which can be copied down to 'Salary Averages by Department'!E7, to calculate the average salary by department and by salary range for all salaries >=$65,000. Again, because there will be multiple criteria for this formula, you must use the AVERAGEIFS function, but the arguments will not be the same as the previous formula. The arguments for this function will be as follows. (Use cell references for all ranges and criterion.) Average Range: Employee's salary Range1: Employee's salary Range Criteria1: > =65000 Range2: Departments Range Criteria2: Department A B C D E F ating Scale: Poor: 4 Fair: 3 Good: 2 Excellent: 1 \begin{tabular}{r|l|c|c|c|c} \hline iployee \# & Department & Salary & Question 1 & Question 2 & Question 3 \\ \hline 42534 & Human Resources & $36,905 & 3 & 1 & 2 \\ \hline 59031 & Customer Service & $42,531 & 2 & 3 & 3 \\ \hline 59044 & Human Resources & $74,078 & 4 & 4 & 1 \\ \hline 52098 & Information Technology & $47,758 & 1 & 3 & 1 \\ \hline 46520 & Underwriting & $76,679 & 1 & 4 & 2 \\ \hline 56714 & Accounting & $66,647 & 4 & 3 & 3 \\ \hline 31533 & Accounting & $36,700 & 2 & 3 & 1 \\ \hline 56831 & Accounting & $78,764 & 1 & 2 & 4 \\ \hline 57441 & Human Resources & $75,940 & 1 & 3 & 2 \\ \hline 46184 & Accounting & $71,723 & 1 & 1 & 1 \\ \hline 53170 & Information Technology & $37,038 & 3 & 4 & 2 \\ \hline 52348 & Accounting & $35,804 & 1 & 1 & 4 \\ \hline 31286 & Customer Service & $54,583 & 1 & 3 & 4 \\ \hline 50128 & Underwriting & $67,099 & 3 & 4 & 3 \\ \hline 49701 & Customer Service & $44,594 & 2 & 3 & 2 \\ \hline 49163 & Information Technology & $77,092 & 4 & 3 & 3 \\ \hline 50149 & Underwriting & $46,447 & 1 & 2 & 3 \\ \hline 35485 & Human Resources & $57,068 & 3 & 3 & 1 \\ \hline 32595 & Customer Service & $71,354 & 4 & 2 & 4 \\ \hline 54127 & Customer Service & $66,717 & 4 & 4 & 3 \\ \hline & & & & & \\ \hline \end{tabular}