Question

In cell i4, enter a formula using averageif function to calculate the average compensation values found in range e4:e16 for records with a permorance ratigng of 5 in range f4:f16.

Options:
a) =AVERAGEIF(F4:F16, 5, E4:E16)
b) =AVERAGEIF(E4:E16, 5, F4:F16)
c) =AVERAGEIF(E4:E16, F4:F16, 5)
d) =AVERAGEIF(F4:F16, E4:E16, 5)

Answer 1

The correct formula to calculate the average compensation values found in range E4:E16 for records with a performance rating of 5 in range F4:F16 is option b) =AVERAGEIF(E4:E16, 5, F4:F16).

Step-by-step explanation:

The correct formula to calculate the average compensation values found in range E4:E16 for records with a performance rating of 5 in range F4:F16 is option b) =AVERAGEIF(E4:E16, 5, F4:F16).

The AVERAGEIF function takes three arguments: range, criteria, and average_range. In this case, range is E4:E16, criteria is 5, and average_range is F4:F16. The function will calculate the average of the values in the average_range that meet the specified criteria.