The columns go to down to row 759. I just need help with the formulas and next steps in the problem. I can't make the image much more clear than that. It doesn't allow me
B D F G K 1 Data Validation and Sumproduct For help, watch this video 2 Your supervisor has asked you to construct a spreadsheet where she can input one or two departments plus the status and the output will list the values for the informaion items listed below. Enter the correct formulas to accomplish this. 3 An example is shown below. 4 (Hint: Lesve a blank cell at the top of your Data Validation list to allow only a single department to be entered if desired. 5 5 Inputs: 7 8 Department ADC or Creative 9 Status Contract 20 11 Outputs: 12 Number of employees 6 3 23 Total Salaries $671,435 4 Average Salary $111,906 15 Average Years 6.67 16 Average Performance Rating 4.50 17 18 Employee Name Department Hire Date Years Status Salary Performance Rating 19 Abbott, James Quality Assurance 4-Feb-07 14 Full Time $69,806 2 20 Acosta, Robert Quality Assurance 30-Mar-14 6 Half-Tim $56,322 1 1 Adams, David Product Development 23-Feb-17 3 Half-Tim $56,760 1 1 22 Adkins, Michael Quality Assurance 6-Mar-18 2 Full Time $63,281 2 23 Aguilar, Kevin Quality Assurance 13 Jun OG 14 Full Time $87,031 3 24 Alexander, Charles Manufacturing Admin 1-Oct-07 13 Hourly $45,403 1 25 Allen, Thomas Manufacturing 4-May 12 7 Full Time $102,023 4 6 Allison, Timothy Creative 13-Feb-19 2 Full Time $124,232 5 17 Alvarado, Sonia IT 25-Oct-18 2 Full Time $98,436 3 28 Alvarez Steven Quality Assurance 19-Mar-18 2 Hourly $61,097 2 29 Anderson, Teason Account Management 6-Sep-06 14 Hourly $72,961 2 30 Andrews, Diane Account Management 24 Sep 05 15 Contract $103,141 4 1 Anthony, Robert IT 6-Sep-17 3 Full Time $119,872 5 32 Armstrong, David Quality Control 6-Mar 05 15 Contract $97,466 4 33 Arnold, Cole Sales 1-Apr-17 - 3 Full Time $75,317 3 34 Ashley, Michael Account Management 29-Nov-17 3 Half-Tim $56,964 2 55 Atkins, Kevin Manufacturing 9-Aug-05 15 Hourly $63,734 2 6 Atkinson, Danielle Account Management 24-Apr-10 10 Half-Time $47,860 1 37 Austin, William Account Management 14-Oct-14 6 Full Time $62,186 2 88 Avila, Jody Quality Assurance 6-Jan-18 3 Hourly $57,173 2 29 Ayala, Polly Account Management 6 May 14 6 Full Time $77,014 3 3 10 Ayers, Douglas Manufacturing 14-Nov-17 3 Contract $86,720 3 11 Bailey, Victor Research Center 7-Apr-10 10 Full Time $106,789 4 #2 Baker, Barney Creative 10-Feb-18 3 Hourly $55,559 2 13 Baldwin, Ray Quality Assurance 23-Jan-07 14 Half-Tim $52,283 1 14 Ball, Kirk Sales 1-Dec-19 1 Full Time $84,093 3 15 Ballard, Martin IT 6-Feb-14 7 Full Time $64,086 2 De 10 10 walu 177 B D F G K 1 Data Validation and Sumproduct For help, watch this video 2 Your supervisor has asked you to construct a spreadsheet where she can input one or two departments plus the status and the output will list the values for the informaion items listed below. Enter the correct formulas to accomplish this. 3 An example is shown below. 4 (Hint: Lesve a blank cell at the top of your Data Validation list to allow only a single department to be entered if desired. 5 5 Inputs: 7 8 Department ADC or Creative 9 Status Contract 20 11 Outputs: 12 Number of employees 6 3 23 Total Salaries $671,435 4 Average Salary $111,906 15 Average Years 6.67 16 Average Performance Rating 4.50 17 18 Employee Name Department Hire Date Years Status Salary Performance Rating 19 Abbott, James Quality Assurance 4-Feb-07 14 Full Time $69,806 2 20 Acosta, Robert Quality Assurance 30-Mar-14 6 Half-Tim $56,322 1 1 Adams, David Product Development 23-Feb-17 3 Half-Tim $56,760 1 1 22 Adkins, Michael Quality Assurance 6-Mar-18 2 Full Time $63,281 2 23 Aguilar, Kevin Quality Assurance 13 Jun OG 14 Full Time $87,031 3 24 Alexander, Charles Manufacturing Admin 1-Oct-07 13 Hourly $45,403 1 25 Allen, Thomas Manufacturing 4-May 12 7 Full Time $102,023 4 6 Allison, Timothy Creative 13-Feb-19 2 Full Time $124,232 5 17 Alvarado, Sonia IT 25-Oct-18 2 Full Time $98,436 3 28 Alvarez Steven Quality Assurance 19-Mar-18 2 Hourly $61,097 2 29 Anderson, Teason Account Management 6-Sep-06 14 Hourly $72,961 2 30 Andrews, Diane Account Management 24 Sep 05 15 Contract $103,141 4 1 Anthony, Robert IT 6-Sep-17 3 Full Time $119,872 5 32 Armstrong, David Quality Control 6-Mar 05 15 Contract $97,466 4 33 Arnold, Cole Sales 1-Apr-17 - 3 Full Time $75,317 3 34 Ashley, Michael Account Management 29-Nov-17 3 Half-Tim $56,964 2 55 Atkins, Kevin Manufacturing 9-Aug-05 15 Hourly $63,734 2 6 Atkinson, Danielle Account Management 24-Apr-10 10 Half-Time $47,860 1 37 Austin, William Account Management 14-Oct-14 6 Full Time $62,186 2 88 Avila, Jody Quality Assurance 6-Jan-18 3 Hourly $57,173 2 29 Ayala, Polly Account Management 6 May 14 6 Full Time $77,014 3 3 10 Ayers, Douglas Manufacturing 14-Nov-17 3 Contract $86,720 3 11 Bailey, Victor Research Center 7-Apr-10 10 Full Time $106,789 4 #2 Baker, Barney Creative 10-Feb-18 3 Hourly $55,559 2 13 Baldwin, Ray Quality Assurance 23-Jan-07 14 Half-Tim $52,283 1 14 Ball, Kirk Sales 1-Dec-19 1 Full Time $84,093 3 15 Ballard, Martin IT 6-Feb-14 7 Full Time $64,086 2 De 10 10 walu 177
