In cell H13, insert of function that will determine the first salary range quartiles for employees, ensuring that row references in the array range are absolute.

C am pegunu poantocm.com/SIMS Services Frame.aspx Anonce Onco-edde Apps G 2 4 OM Outlook Mail UNG M Malfway I Alger 5 SIMS 3 Share File Horre Insert Page Layout Formulas Dat 12 Logical- 12 Lookup & Reference Recently Used - A Text- 10 Math & Trig Insert Function 12 Financial Date & Time - More Functions. Function Library fx retos BANNER CDL Com - Zoom Academic catalog Panson 088alaryan - Excel Review View Tell me what you want to do Define Name Trace Precedents FC 60 Use in formula Trace Dependents. Name Watch Manager Create from Selection Remove Arrows- Window Options Defined Names Formula Auditing Caution Calculation F G H 1 . Simulary Count Total payroll Average Salary Hired before 2010 24 $ 1,114,661.00 $ 46,444.21 7 3 37 45 9 ES X-RANK AVG(C3.C$3:C552) A B C D E 1 Salary Information 2 Imployee Name Hire Date Salary Division Rank 3 Karo 421/2005 $ 73,074.00 Corporate 4 Han 10/20/2018 $ 49,934.00 Sales 5 Yoon 4123/2014 $ 74,042.00 Sales 6 Lopez 7/30/2016 $ 44,404,00 Corporate 7 Yamamoto 12292007 $ 42.793.00 Corporate BLPP 4/16/2014 $ 48,827,00 Corporate 9 Garcia 4/23/2000 $ 47,407.00 Corporate 10 Thomas 10/2/2007 $ 48,484.00 Customer Service 11 GO 7/16/2006 $ 47.474.00 Sales 12 Cruz 8/6/2011 $ 70,934.00 Corporate 1a Cruz 9/11/2006 $ 48,344.00 Customer Service 14 Ort 8/16/2009 $ 47,494.00 Sales 15 Rodriguez 8/4/2008 $ 44,834,00 Corporate 36 Me 1/21/2010 $ 47,288.00 Sales 17 Young 9/4/2010 $ 40,920.00 Corporate 18 Jhadav 8/3/2006 $ 44,944,00 Corporate 19 jayaraman 10/14/2017 $ 74.273.00 Customer Service 20 Sanchez 9/30/2009 $ 44403.00 Customer Service 9/30/2016 44.247.00 Corporate Salary Data 0 Customer Service Employees Hired before 1/1/2010 Count 8. Total Payroll $ 359.417.00 Average Salary $ 44.927.13 19 11 17 6 Quartile Salary (QUARTILE EXC) 13 1 2 3 16 27 20 48 25 2 38 4:13 PM 2012021 Ask me anything