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
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
Get step-by-step solutions from verified subject matter experts
