[Solved] Npex168ataylorleblanc1 1 Q Search Sheet Home Insert Page Layout Formulasdata Review View T Q37212306
needhelp with 14-16
NP_EX16_8a_TaylorLeblanc_1(1) Q Search Sheet Home Insert Page Layout FormulasData Review View Table Insert Delete Wrao Text Calibri (Body) 11 AA General | $ % , |업 Conditional Forable Stylo Sort & .. Merge & Center , Fornating as TabieyleFoFiter Years since First Ald Candidate for Base Salary First Aid Certification Year Leadership TrainingTransportation Group Leader Bunk Leader Graduate 1 No Staff ID Staff Name Service Years 2 No 2 Yes 1 Yes Trained Staff All Staff Service Years Base Salary 31 17.50 Safari ..ndle & SAM Project la New Perspectives Excel 2016 | Module 8: SAM Project la 14. Dean wishes to determine several totals and averages for his staff. In cell Q9, enter a formula using the COUNTIF function and structured references to count the number of staff members who have participated in Leadership Training. 15. In cell R9, enter a formula using the AVERAGEIF function and structured references to determine the average the number of service years of staff members who have participated in Leadership Training as shown in the Service Years column. In cell R10, enter a formula using the AVERAGE function and a structured reference to determine the average number of years of service of all staff as shown in the Service Years column. 16. Your workbook should look like the Final Figures on the following pages. Save your changes, close the document, and then exit Excel. Follow the directions on the SAM website to submit your completed project Fingl Fiqure 1 Staff Listing Worksheet-Columns A:N Show transcribed image text NP_EX16_8a_TaylorLeblanc_1(1) Q Search Sheet Home Insert Page Layout FormulasData Review View Table Insert Delete Wrao Text Calibri (Body) 11 AA General | $ % , |업 Conditional Forable Stylo Sort & .. Merge & Center , Fornating as TabieyleFoFiter Years since First Ald Candidate for Base Salary First Aid Certification Year Leadership TrainingTransportation Group Leader Bunk Leader Graduate 1 No Staff ID Staff Name Service Years 2 No 2 Yes 1 Yes Trained Staff All Staff Service Years Base Salary 31 17.50 Safari
..ndle & SAM Project la New Perspectives Excel 2016 | Module 8: SAM Project la 14. Dean wishes to determine several totals and averages for his staff. In cell Q9, enter a formula using the COUNTIF function and structured references to count the number of staff members who have participated in Leadership Training. 15. In cell R9, enter a formula using the AVERAGEIF function and structured references to determine the average the number of service years of staff members who have participated in Leadership Training as shown in the Service Years column. In cell R10, enter a formula using the AVERAGE function and a structured reference to determine the average number of years of service of all staff as shown in the Service Years column. 16. Your workbook should look like the Final Figures on the following pages. Save your changes, close the document, and then exit Excel. Follow the directions on the SAM website to submit your completed project Fingl Fiqure 1 Staff Listing Worksheet-Columns A:N
Expert Answer
Answer to NP_EX16_8a_TaylorLeblanc_1(1) Q Search Sheet Home Insert Page Layout FormulasData Review View Table Insert Delete Wrao T… . . .
OR
