Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please answer 16 14. Finally, Luke-wishes to determine-how-many staff-members-have Academic Technology training, as well as-their average-level-of experience. In-cell-Q9, enter a-formula using-the-COUNTIF-function and-structured- references to-count-the-number of-staff
Please answer 16
14. Finally, Luke-wishes to determine-how-many staff-members-have Academic Technology training, as well as-their average-level-of experience. In-cell-Q9, enter a-formula using-the-COUNTIF-function and-structured- references to-count-the-number of-staff with-Academic-Technology-trainin 15.- In-cell-R9, enter a-formula-using the AVERAGEIF-function-and-structured- ences to-determine the average service-years of-staff-members with refer Academic-Technology-training as-shown-in-the Service-Years-column.5 16. 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.1 Your-workbook should-look-like the Final-Figures-on-the following-page. -Save your- changes, close-the document, and-then-exit-Excel. Follow-the-directions-on-the SAM website-to submit your completed project.1 Final Figure 1: Staff Listing Worsheet-Columns A:N AND function-O..XNP EX6 bS Lexar(F)Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started