Explore Westonci.ca, the top Q&A platform where your questions are answered by professionals and enthusiasts alike. Connect with a community of experts ready to provide precise solutions to your questions on our user-friendly Q&A platform. Get quick and reliable solutions to your questions from a community of experienced experts on our platform.

Tiana also wants to average the combined scores for each employee. In cell N5, enter a formula using the AVERAGEIF function and structured references to the Service rep and average columns in the calls table to average scores Barry (L5) received for all the calls he handled. Fill the formula into the range N6:N13 without formatting

Sagot :

Answer:

=AVERAGE(N1:N5)

Explanation:

In this exercise we have to use excel knowledge to write the formula that best describes the event, so we have:

=AVERAGE(N6:N13)

What is a average function?

Returns the average (arithmetic mean) of the arguments. For example, if the range A1:A20 contains numbers, the formula =AVERAGE(A1:A20) will return the average of those numbers.

See more about excel at brainly.com/question/12788694