Question

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.9. Lael wants to determine several totals and averages for active students. In cell Q8, enter a formula using the COUNTIF function and structured references to count the number of students who have been elected to offices in student organizations.

Answer 1

To calculate the average number of post-secondary years for elected students, use the AVERAGEIF function with structured references.

To count the number of elected students, use the COUNTIF function with structured references.

In cell R8, you can enter the following formula:

=AVERAGEIF([Elected],"Yes",[Post-Secondary Years])

This formula uses the AVERAGEIF function to calculate the average number of post-secondary years for students who have been elected.

The structured references are used to refer to the specific columns containing the information.

For cell Q8, you can enter the formula:

=COUNTIF([Elected],"Yes")

This formula uses the COUNTIF function and structured references to count the number of students who have been elected to offices in student organizations.