10. In cell R8, enter a formula using the AVERAGEIF function to determine the average number of post-secondary years for students who have been elected.

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.

answer; peter zenger;