$(0-10$ pts$)$ Write an Excel function in cell Gymnast!I$2,$ which is to be copied down, to determine Search

AutoSave

Off

Search

le Home Insert Page Layout Formulas Data Review View Help

Clipboard

Font

Alignment

Number

Conditional F $$

$12$

$A^A$

Paste

B

I

$U_{?}$

$q,$

$$

$$

A

v

$$

$20\%$

$$

ab

$-=$

$

$\%$

$,$

$lar{r}_{\mathrm{.}0}^{0}0$

Number

Format as Tak

Cell Styles v

F

Styles

$12$

A

Gymnast

Team Summary

Levels

Events

Ready

Accessibility: Investigate

Search

the gymnast's overall average score. An individual's overall average score is determined from the

average scores of the individual events. $($Hint: Use the AVERAGE$()$ function here with a range for

individual average event scores from the Events worksheet columns K$,$ L$,$ M$,$ and N$.$ Remember to

always check for if a $ is needed for the numbers in any cells used since you are copying this

function down.$).$

$=$AVERAGE $($average range in Events worksheet for average score for each event$)$

$=$AVERAGE$($