manager at an educational institution is designing a learning management system $($LMS$)$ and has tasked u to design a Google Sheets document with the functionality needed for their new information system. ing the provided graphic as a reference, design functions to accomplish the organization goals by oosing the best answer among the options provided.

Q Which formula would provide the class average grade?

A

$\backslash$table$[[,$A$,18,$c$,$D$.,$F$,f^2,,10,y^1,$u$.],[$I$,$Student Grade Sheet,,Angonent,HW $1,$HW $2,$Test,Room List$],[2,,$Clial Axerspe,,,$],[1,,$floom,Polits,Total,Funleride,El$,$Nu$,N,$Studant,Deam$],[4,$Bue$-0145,,,300,,62,78,67,$Rud$-2349,$A$],[s,$B ver$-0234,,,300,1,69,72,76,$Rud$-1029,$A$],[$t$,$Green$-2746,,,300,4,85,10,A,$Greun$-2746,$B$],[3,$Green$-8827,$in$,[,300,,92,\frac{0}{b}ar(9),18,$Green$-[$iA$,2),$A$],[$B$,$Roc$-1029,8,68,300,,75,85,n,$Blun$-0234,$B$],[9,$Rod. $2349,4,1,300,,68,99,64,$Bline$-0145,[]]]$

$=$AVERAGE$(F4$:$H9)$

$=$AVG$(F4$:$H9)$

$=$AVERAGE$(F4$:$H4)$

$=$AVG$(F4$:$H4)$