contestada

10. In cell r8, enter a formula using the averageif function and structured references to determine the average number of post-secondary years for students who have been elected

Respuesta :

MrRoyal

The formula is an illustration of Excel functions and formulas

The formula to enter in cell R8 is =AVERAGEIF(M2:M31,"Elected",D2:D31)

How to determine the formula

The AVERAGEIF function is used to calculate the average of a range of numbers if a certain condition is true.

From the complete question,

The range is M2 to M31

The condition is to check is the students in range D2 to D31 have been elected

The syntax of the AVERAGEIF function

=AVERAGEIF(range,criteria,average_range)

So, the formula to enter in cell R8 is =AVERAGEIF(M2:M31,"Elected",D2:D31)

Read about Excel formulas at:

https://brainly.com/question/19595618

Otras preguntas