Question: i need help with #10, it must be a structured reference 9. Loel wants to delermine several totals and averoges for octive students. In cel

i need help with #10, it must be a structured reference
i need help with #10, it must be a structured reference 9.

9. Loel wants to delermine several totals and averoges for octive students. In cel Q8, enter a formuia using the COUNTF. function and structured references to count the number of studients who have been elected to offices in student organizations. Create a formula using a function. In the Student Reptesentatives worishoet, the focmula in cel Q8 should use a structured ceference to the Elected column in the Studentreptesentafives table in the range argument of the COUNTF function. 10. In cel R8, entor a formula ving the AVERAGEF function and structured references to determine the average numbor of post-secondary yeors for students who have been elected. X Create a fomula ving a function. In the Student Representatives woiksheet, the formuia in cet Ris should use a structured reference to the Bexcled colurn in the StudentRepresentatwes foble in the range argument of the AVERAGEF funcfion

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!