10. In cell R8, enter a formula using the AVERAGEIF function to determine the average number of post-secondary years for student

Question

Nikitich [7]

2 years ago

9

10. In cell R8, enter a formula using the AVERAGEIF function to determine the average number of post-secondary years for student

s who have been elected.

Computers and Technology

1 answer:

mart [117] · Answer 1 · 2022-09-21T21:33:45+03:00

Answer:

On cell R8, type in the formula "=AVERAGEIF(M2:M31,"Elected",D2:D31)".

Explanation:

Microsoft Excel is a spreadsheet application developed by Microsoft as a part of the office package, used for statistical analysis of data. It has several tools used for this purpose.

The AVERAGEIF function is used to give the average of numeric column based on a condition. The formula above uses the word 'Elected' in the M column to calculate the average of numbers in the D column.