Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Provider Audit In England Evaluating Medical Audit

Authors: James Buttery, Yvette; Walshe, Kieran; Rumsey, Moira; Amess, Moyra; Bennett, Jennifer & Coles

1st Edition

1898845034, 978-1898845034

More Books

Students also viewed these Accounting questions

Question

Influences on Nonverbal Communication?

Answered: 1 week ago