Explore a diverse range of topics and get answers from knowledgeable individuals on IDNLearn.com. Ask your questions and receive accurate, in-depth answers from our knowledgeable community members.

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