Please show/provide steps for each question

1.Format the salary column into s

2.Sort the entire table so that it is listed alphabetically by name

3.Please use a vlookup formula in cell F3 to find Bryan Sloanes salary

4.Sum all of the salaries in cell C56

5.In Cell B57 please use a "Count if" formula to calculate the number of production staff

6.In cell C57 use a "SUM IF" formula that will just sum all of the Sales Salaries

B C F G H I J K L M N 0 P Q Bryan Sloane Name Salary Questions 1 2 3 3 4 5 6 Format the salary column into Es Sort the entire table so that it is listed alphetically by name Please use a vlookup formula in cell F3 to find Bryan Sloanes salary Sum all of the salaries in cell C56 In Cell B57 please use a "Count if" formula to calculate the number of production staff In cell C57 use a "SUMIF" formula that will just sum all of the Sales Salaries Full name Abigail Aalderink Andrew Gupta Annie Hunter Apple Lyn Bobbi Simon Bradley Sack Bryan Sloane Caylie Price Chatsworth Miller Chris Borgogni Daniel Turek Daniella Ruder Darrel Hobbs David Goods David Jones David Jones Elly Kam Emily Bodenham Irene Pawell Jake Fann Jake Prock James Sperman Jaremy Davis Joe Keenan John Dumas Jonny Chan Kristi Hines Lee Nazal Lindsy Kline Lorna Walker Mai Taylor Mark Cox Mary Oms Matt Baker Mike O'Neil Mitch Gramlow Nate Harris Peter Bowland Richard David Robert Nole Sam Zaborszky Samuel Bartnick Sanford Bartolo Sarah Smith Scott Jastrow Scott Joyce Stephanie Miller Steven Davidson Steven Lamar Steven Perry Susan Ricas Tom Briones Valerie Stevens Vicky James - Department Salary Sales E 60,569.00 Adm E 92,985.00 Marketing E 60,691.00 IT 75,144.00 Marketing E 65,237.00 IT f 64,717.00 IT E 74,243,00 Adm E 62,683.00 Marketing E 71,358.00 Sales 89,758.00 Sales 74,419.00 Adm f 71,400.00 Sales E 98,302.00 Sales f 79,876.00 Production E 99,458.00 Production 66,117.00 Adm E 63,434,00 Production 77,380.00 Sales E 61,225.00 Accounting 99,196.00 Marketing E 62,774.00 Sales 68,451.00 Adm E 65,200.00 Accounting 75,120.00 IT 84,186.00 IT f 60,682.00 Production E 85,775.00 HR f 82,162.00 Marketing 98,915.00 Sales E 62,552.00 IT E 69,213.00 IT f 68,685.00 Sales E 62,108.00 Sales E 60,623.00 HR 72,254.00 Production f 89,276.00 HR 70,556.00 Production 65,722.00 HR E 95,459.00 Production E 69,573.00 Accounting E 85,065.00 Sales 86,281.00 Sales E 81,603.00 Production E 86,438.00 Accounting E 94,358.00 Adm f 63,713.00 Adm E 84,889.00 Adm E 62,637.00 Sales 64,931.00 Production f 61,173.00 Adm E 95,055.00 IT E 70,988.00 Sales E 72,179.00 HR E 83,207.00 9 4069995 1022877