$6.$ Create a worksheet named, $$Salary Averages by Department$.$ The formatting of the worksheet should look like the figure below. $($All formatting can be approximated.$)7.$ Write a formula in cell $$Salary Averages by Department$!$B$3,$ which can be copied across to cell $$Salary Averages by Department$!$D$3,$ and down to $$Salary Averages by Department$!$D$7$ to calculate the average salary by department and by salary range. $($Do not copy the formula to column E as you will need another formula for that column.$)$ The salary ranges are as follows. $$30,000-$ $$44,999\mathrm{.}99$ $$45,000-$ $$54,999\mathrm{.}99$ $$55,000-$ $$64,999\mathrm{.}99>=$ $$65,000$ Because there will be multiple criteria for this formula, you must use the AVERAGEIFS function. The arguments for this function will be as follows. Also, use the IFERROR function to return $0$ if a department doesn$$t have salaries within a range. If you don$$t use the IFERROR function, Excel will return error messages. $($Use cell references for all ranges and criterion.$)$ Average Range: Employee$$s salary Range Range$1$: Employee$$s salary Range Criteria$1$: $>=30000$ Range$2$: Employee$$s salary range Criteria$2$: $<45,000$ Range$3$: Departments Range Criteria$3$: Department $($Add the appropriate $ to each cell reference.$)$ If you write this formula correctly, you will only need to write one formula and copy it over and down. $($Remember$,$ do not copy the formula to column E$.)$ B $$ D E N $1$ Average Salary by Department and Salary Range $ $30,000\mathrm{.}00$ $ $45,000\mathrm{.}00$ $ $55,000\mathrm{.}00$ $ $65,000\mathrm{.}003$ Accounting $4$ Customer Service $5$ Human Resources $6$ Information Technology $7$ UnderwritingA B C D E G H J K L M N Question $8$ Question $9$ Question $10$ Question $11$ Question $12443443322444123333212.1434132113114124131114411$ Rating Scale: Poor: $4$ Fair: $3$ Good: $2$ Excellent: $12$ Employee # Department Salary Question $1$ Question $2$ Question $3$ Question $4$ Question $5$ Question $6$ Question $342534$ Human Resources $$36,9053121232459031$ Customer Service $$42,5312333321559044$ Human Resources $$74,0784411234552098$ Information Technology $$47,7581312.412746520$ Underwriting $$76,6791423111356714$ Accounting $$66,6474334233231533$ Accounting $$36,7002313223$ LO $56831$ Accounting $$78,7641241241157441$ Human Resources $$75,9401322421246184$ Accounting $$71,7231112324353170$ Information Technology $$37,0383422423452348|$ Accounting $$35,8041143341-531286$ Customer Service $$54,5831343412$ L$650128$ Underwriting $$67,0993433414-749701$ Customer Service $$44,5942323134849163$ Information Technology $$77,0924334312950149$ Underwriting $$46,4471232.114$ CO $35485$ Human Resources $$57,0683313234132595$ Customer Service $$71,3544243141-254127$ Customer Service $$66,7174431242-33431214141424414311314413331312234342422341213423423142$