Write an Excel formula or formula in cell Events!G3, which can be copied down the column and across the row to column J, to determine the Performance Round the gymnast will perform in for the corresponding event. If they are not performing in the event put a - in the cell.

Write an Excel formula and/or function in cell Events!T3, which can be copied down the column, to determine if the gymnasts all-around score is greater than their teams average score(TRUE or FALSE).

A B C D E E F G H H I J L M N O P Q Q R R S S T Individual All Around Score Score More than Team's Avg 1 Entry Team Medals Performance Round bars floor 2 beam vault bars floor vault Performed in Event beam bars floor vault TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE 3 1001 MSU Silver 37.70 37.70 4 1002 OSU Bronze Bronze 5 1003 MSU TRUE TRUE TRUE 37.37 37.30 6 1004 Gold TRUE TRUE Bronze IU MSU OSU IU IU Gold TRUE TRUE TRUE TRUE FALSE | TRUE FALSE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE Average Score beam bars floor vault beam 9.33 9.42 9.65 | 9.30 - 9.67 8.90 9.63 9.50 Gold 9.48 8.959.54 | 9.40 Silver 8.98 | 9.48 9.55 9.30 | 8.75 9.46 | 9.48 9.22 0.00 9.25 9.70 9.33 0.00 8.90 8.92 | 9.13 9.45 8.55 9.05 | 9.45 9.30 9.45 9.38 | 9.25 8.58 8.90 8.80 9.54 9.28 8.00 9.25 9.66 8.90 8.60 8.50 9.45 9.46 9.05 0.00 8.98 Bronze 9.30 9.479.13 9.32 0.00 9.048.98 | 9.48 7 1005 8 1006 9 9 1007 10 1008 11 1009 12 1010 13 1011 14 1012 15 1013 16 1014 17 1015 18 IU 36.91 28.28 26.95 36.50 37.38 35.82 36.19 35.45 TRUE TRUE TRUE TRUE OSU Silver Gold OSU MSU TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE FALSE TRUE FALSE IU OSU TRUE 27.49 37.22 TRUE Silver TRUE TRUE MSU TRUE 27.50